What is the correct way to format so that the Delete Command can delete a CatName that has bee incorrectly entered with an apostrophe or single quote.
I've tried a paste of the CatName from the table but no luck
delete from table where catname = '''Allo';
That sould work. To escape a ' you need to repeat it '', and since it comes at the beginning you need to use 3 of them.
It didn't seem to work ' ' 'Allo' but it didn't see it as a syntax error
Did you do it with those spaces? There shouldn't be any spaces. But if it still doesn't work you can try catname = '\'Allo\''
escaping the ' with \'.
