Match Case

wessamzeidan

wessamzeidan

Well-known member
Joined
Dec 8, 2002
Messages
379
Location
Lebanon
Hi, I want to query a database for a string, but I need to match the string case.

For example, if I have DotNet in my table and I use the following select statement

select * from table where name=dotnet

the query should return no rows, how do I do that??

thanks
 
wessamzeidan said:
Hi, I want to query a database for a string, but I need to match the string case.

For example, if I have DotNet in my table and I use the following select statement

select * from table where name=dotnet

the query should return no rows, how do I do that??

thanks
Click to expand...
I believe you need to redefine all tables creations that you want to do this with to specify an alternative collation type for the column you want to be case sensative. . .

lookup the COLLATE key word. I believe you want the Latin1_General_CS_AI
collation
 
wessamzeidan said:
you mean, this is the collation type that I need
Click to expand...
yes. . . Latin Case Sesitive accent insensitive. . .

There is a select statement you can use to get the available types. . . look up collate keyword in the T-sql help
 
Back
Top