Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
where rate_desc='N'&chr(39)&'cash' ;
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
Thanks dear, i have done with your help.
Regards,
Zain.
Thanks for your reply.
Regards,
Zain.