Help working around single quote in string

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Help working around single quote in string

Message

From

16/03/2010 12:47:12

16/03/2010 11:24:38

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01454787

Message ID:

01454841

Views:

It should be STRTRAN

lcUpdateString = STRTRAN(lcUpdateString, ['], [''])

>
>>A simple fix is to double a single quote as you would do in SQL Server
>>

>>lcUpdateString = CHRTRAN(lcUpdateString, ['], [''])
>>

>>
>>

--sb--