>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

William seems to already answered the question - by default SQL Server is case insensitive, but you can always change the behavior by adding COLLATE clause when comparing character data.