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

Re: case sensative search
 

Use the Strcomp() function

Re: case sensative search
 

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

Re: case sensative search
 

Try using this query

Re: case sensative search
 

Thanks a lot I think Its working.

Many thanks for co-operation

neeraj

Re: case sensative search
 

The pleasure is all mine!

Re: case sensative search
 

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.

Re: case sensative search
 

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

sorry of inconvinence