CODE EXAMPLE FOR SQL

sql String comparisons case sensitive

select * from Person.Person 
where FirstName = 'Ken'	COLLATE Latin1_General_CS_AS