case sensativity in a query

[Chris Giminez]

The query below will return a match without regard to the case

"password" in the database returns a record when matched with "PASSWORD" or "PaSSwORd" 
when I want
it to return a record with "password" exactly.

How can I force a case sensative query?

<CFQUERY NAME="login" DATASOURCE="datasourse">
SELECT Count(*) AS loggedin
FROM admin_pass
WHERE username = '#trim(FORM.username)#'
AND password = '#trim(FORM.password)#'
</CFQUERY>

Thanks,

Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000






------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.