How do i perform a case sensitive search??

From: Michael (michael_at_mikeymall.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 23:09:21 +0800

i've just realized i've installed my mssql to be case-insensitive, now all
my queries seems to be case insensitive.

Is there any workaround?? How should i write my sql statements to be case
sensitive now??? because i get the same results for:

1:
select * from members
where user = 'abc'
and password = 'AbCd'

2:
select * from members
where user = 'abc'
and password = 'abcd'

Relevant Pages

  • Re: Need help with user-written routine in SOR$
    ... > ADRS2 is the other record contents by reference ...
    (comp.os.vms)
  • Repost: DrawString and ellipsis problem ... please help
    ... I have a rectangle with a string inside and the user can drag the mouse ... a string "abcd" is progressively displayed as: ... abc... ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: File parsing
    ... Build an array or associatiave array... ... I can NOT read until the next occurance ot "abc"- abc 5 ...
    (comp.lang.awk)
  • DrawString and ellipsis problem
    ... I have a rectangle with a string inside and the user can drag the mouse ... While shrinking, a string "abcd" is ... abc... ...
    (microsoft.public.dotnet.languages.csharp)
  • DrawString and ellipsis problem
    ... I have a rectangle with a string inside and the user can drag the mouse ... While shrinking, a string "abcd" is ... abc... ...
    (microsoft.public.dotnet.framework.drawing)