That may be so but you can't get CHRTRAN to turn a single ' into a double ''
Just wanted to point this out so other people don't waste their time trying to get this to work with CHRTRAN.
>CHRTRAN() is much faster than STRTRAN().
>
>Vlad
>
>>You have two solution available to you. The first is to convert the single single-quote to two single quotes. SQL Server sees this as a literal single quote. You ought to be able to use STRTRAN() to do the convertion:
>>
>>lcDiary = STRTRAN(lcDiary, "'", "''")
>>
>>The second solution involves issuing the SET QUOTED_IDENTIFIER OFF. This will allow SQL Server to receive strings that are delimited by either a single or double quote.
>>
>>-Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only