>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

No. Only be aware it means set exact on for SQL. ie:

set ansi on
select * from customer where cust_id = 'A'

would return no records.
select * from customer where cust_id = 'ALFKI'
would return a record.
Cetin