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.