>>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.


Then why answer it again?