Selects with case sensitivity

[Barry]

Hello All,

I am a semi-newbie so this should be a super easy one. I am doing a simple
authorization db for our web server. As a test I created the following db.

Auth
  User  char(32)
  Pwd   char(16)

and entered the following

  User     Pwd
  Barry    Sch

if I do the any of the following in the utility myAdmin

  Select * from Auth where User='Barry' and Pwd='Sch'
  Select * from Auth where User='barry' and Pwd='scH'
  Select * from Auth where User='BARRY' and Pwd='sCh'


it returns the Barry Sch row shown above.

I would like to do a Select where User is not case sensitive, but where Pwd
is case sensitive. Searching the manual I came up with:

  Select * from Auth where User='barry' and strcmp(Pwd,'Sch')=0

It does what I want. Is this the best way?

Thanks,
Barry.