Re: Case sensitive

From: Forced Microsoft User <berdii_at_techemail.com>
Date: Fri, 19 Apr 2002 13:10:41 +0200
Message-ID: <a9otvb$mvi$1@ail.sri.ucl.ac.be>

Thank you for your response, but my problem is using case sensitive on data

eg : if in my table "MyTable" I have some record in the field "MyField" with uppercase and lowercase
When I do : select * from MyTable where MyField like "d%", I match only records beginning whith 'd' in lowercase and not those beginning with 'D' in uppercase

So I want to know how changing system configuration to be able to select all the data

Thanks for any response Received on Fri Apr 19 2002 - 06:10:41 CDT