frdep
asked on
UpperCase in a Query
How can I have uppercase in a sql query ?
I'm using a Paradox file, and in a TQuery I have :
SELECT * FROM MyTable WHERE UPPERCASE(Name) = 'HELLO'
It do not work :(( Â How can I do that ??
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT * FROM MyTable WHERE UPPER(Name) = 'HELLO'