case sensative search

hi everyone

I want to have case sensative serarch

as
northwind-employees table

select * from employees where firstname = "Nancy"

and
select * from employees where firstname = "NANCY"

should not fetch same results


please help me.

it is very urgent

 

Use the Strcomp() function

Code:

select * from employees where StrComp(firstname, "Nancy", 0)

Code:

select * from employees where StrComp(firstname, "NANCY", 0)

 

Sorry It dosen't work, It fetch all the records from the table.

 

Try using this query

Code:

SELECT * FROM employees WHERE StrComp(firstname, "NANCY", 0)=0

 

Thanks a lot I think Its working.

Many thanks for co-operation

neeraj

 

The pleasure is all mine!

 

Pradeep Ji, Please help me once again

how to solve this problem with strcomp.. as I using Like funciton in the query
Tis is a sql query mentioned in vb module --
srtext - variable
select * from data where strcomp(trim(userike '" & Trim(srtext) & "%',0)=0


thanks in advance.

 

sorry the query was :
"select * from data where trim(hindi) like '" & Trim(srtext) & "%'"

sorry of inconvinence