Where Clause text literal issue

[#1]

Dear,

kindly guide me how to ignore ' in text literal when using in conditon for example,

load *

where rate_desc='N'cash'; its show me error. Condition value is N'cash

[tresesco · Accepted solution]

Try like:

where rate_desc='N'&chr(39)&'cash' ;

[amit_saini]

Hi Zainulabedeen,

If you want to ignore N'cash , Try this:

where rate_desc <>' N'cash' ;

or try this:

where rate_desc <>'N'&chr(39)&'cash' ;

Thanks,
AS

[#4]

Thanks dear, i have done with your help.

Regards,

Zain.

[#5]

Thanks for your reply.

Regards,

Zain.