How to check in where clause ?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Supriya.S Ten Centuries Points: 1131 More actions · Answer 1

Try this:

SET QUOTED_IDENTIFIER OFF

GO

Select *

from t

where c1 = "ASO '02 CHOICE 06"

HTH,

Supriya

Cnu2010 SSC Enthusiast Points: 126 More actions · Answer 2

SSC Enthusiast

Points: 126

September 30, 2009 at 9:39 am

Thanks for help.

Its working supriya.

Cnu

AR-777 Ten Centuries Points: 1288 More actions · Answer 3

Also,

if you want to avoid

SET QUOTED_IDENTIFIER OFF

you can also use this

Select *

from t

where c1 = 'ASO ''02 CHOICE 06'

here there are two single quotes before 02 which sql reads as a single quote when used in a string