mud2
07-30-2009, 09:03 AM
A few weeks ago I asked for help because my string searches were not case sensitive. I received several useful suggestions...all with strcomp.
If you set up your searches in a MODULE and use OPTION COMPARE BINARY in the declarations section of the module, then simple comparisons..."Owen" = "oWen" will be case sensitive (= FALSE). otherwise, will = TRUE!
Some other incomprehensible restrictions may apply!
Calling a query with a "condition" from the OPTION COMPARE BINARY module will NOT work! As far as I can see (not very far), the programmong must be in the module!
If you set up your searches in a MODULE and use OPTION COMPARE BINARY in the declarations section of the module, then simple comparisons..."Owen" = "oWen" will be case sensitive (= FALSE). otherwise, will = TRUE!
Some other incomprehensible restrictions may apply!
Calling a query with a "condition" from the OPTION COMPARE BINARY module will NOT work! As far as I can see (not very far), the programmong must be in the module!