I have some string entries as [Baghdad] (the square brackets are part of the string)
If I query on "[Baghdad]" it finds them
If I use "*baghdad]" it also finds them
BUT if I query using like "[baghdad]" it does not find them
Even stranger if I search on like "*[Baghdad]" it brings up about 70 records which have no connection to Baghdad whatsoever!
All this leads me to conclude that the Like statement cannot be used if the first character is a square bracket so I am asking
a. Is this true?
b. Which other characters does it apply to?
c. What can be done to overcome this?
Thanks
If I query on "[Baghdad]" it finds them
If I use "*baghdad]" it also finds them
BUT if I query using like "[baghdad]" it does not find them
Even stranger if I search on like "*[Baghdad]" it brings up about 70 records which have no connection to Baghdad whatsoever!
All this leads me to conclude that the Like statement cannot be used if the first character is a square bracket so I am asking
a. Is this true?
b. Which other characters does it apply to?
c. What can be done to overcome this?
Thanks