>Hi.
>Say I have a table with two Rows, and the Values are 'TEST' and 'test'
>In VFP, if I select MyCode from MyTable where MYCODE = 'TEST' , one row is returned
>In Sql, if I do the same , two rows are returned
>
>I can live with this in a standard select, but if i am joining two tables, I get two rows instead of one returned.
>Is there any setting in the DataBase which will 'SET CASESENSITIVITY ON' so that case is adhered to in Selects (And Updates / Deletes)
>
>Tia
>Gerard
Depends on setting of COLLATE.
See
http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________