>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!
Sylvain Demers