John Baird
Coatesville, Pennsylvania, United States
>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only