>Hello all,
>i have set "exact on" in a program file which has all the environmental settings but after running this file at the beginning of my application
>i do not seem to benefit from the "set exact on" effect so my seaches bring close matches like AZ200, AZ2002.
>Help please.
>TIA
>.
Sammy,
I think you mean SQL searches ? In SQL you need set ansi on instead.
However you might leave set exact and set ansi at their default settings (off) and use == instead.
ie:
lcSearch = 'AZ200'
select * from myTable where myField == lcSearch
doesn't bring AZ2002.
Cetin