Thanks Cetin,
Actually i have used sql searches extensively in my application
so i am tempted to set ANSI ON which is the easy way out instead of making the necessary modifications to my sql.
Are there any risk/considerations to SET ANSI ON?
Please advise.
TIA