>Hello,
>
>I'm using this SQL statement:
>
SELECT * from Test WHERE CHRTRAN(cName,' ','') = "GAMMARES"
>
>The result will also give records like "GAMMA". However, "GAMMA" = "GAMMARES" returns .F. Why does the result include these records?
>Thanks.
If SET ANSI is set to ON then there is no match.
If SET ANSI is set to OFF then the result will be as you have indicated as GAMMA is contained within GAMMARES.
You can also use == to indicate "exactly equal to".
Tom