>If double quotation marks are used, embedded single quotation marks do not have to be denoted by two single quotation marks:

ie:
SELECT * FROM [My Table]
WHERE [Last Name] = 'O''Brien'

Chris, change your routine that eliminates quotation mark and make it double them - you can use STRTRAN(cString, ['], ['']) and you won't need to use the QUOTED_IDENTIFIER thing!