SQL Statement case sensitive

[abcfantasy]

I've got an SQL SELECT statement which uses the WHERE clause and takes two parameters.

If for example the parameter is ABC, the Select command also returns those fields that match 'abc' and i don't want this.

I've got the following in the statement: WHERE ( field = @value )

How can i make it case sensitive?

Hope i was clear
Any help is appreciated

ABC -

http://www.abcfantasy.tk

 

[markknowsley]

Try putting the following statement into Google:

'make sql statement case sensitive'

and you'll find the answer in about 5 seconds.

Failing that, the statement you need is:

SELECT * FROM tablename WHERE columnname COLLATE Latin1_General_CS_AS = 'QUERY'

where 'QUERY' could also be 'query' or 'Query' or any other combination of upper and lower case thereof.

 

[abcfantasy]

Thanks for the quick reply.

I had searched on google but i think i used wrong keywords.

Well thanks again i'll try that out as soon as I'll be home.

ABC -

http://www.abcfantasy.tk