Perform a case sensitive search

[arphex]

Hi all,

Is it possible to make a case sensitive search?

I want so search for lowerLimit and the search returns all:

LOWERLIMIT, lowerlimit and lowerLimit

thx

[qwerty]

It depends on the underlying database. Some are case sensitive others aren't.

q.

[Geert Bellekens]

If you are on SQL Server that might be possible if you include the collection into your query.
I found this on the interwebs (but I haven't tried it myself)

http://SELECT *
FROM dbo.CaseSensitiveTest
WHERE Value1 LIKE '%Test%' Collate SQL_Latin1_General_CP1_[highlight]CS[/highlight]_AS
where apparently the CS part means Case Sensitive (as opposed to CI for Case Insensitive)

Geert