[bhushan98]

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

[pradeep]

Use the Strcomp() function

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

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

[bhushan98]

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

[pradeep]

Try using this query

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

[bhushan98]

Thanks a lot I think Its working.

Many thanks for co-operation

neeraj

[pradeep]

The pleasure is all mine!

[bhushan98]

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.

[bhushan98]

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

sorry of inconvinence