Case Sensitive Search in MS SQL Server 2005

If you want Case Sensitive search in SQL Server 2005 Query then try this:


select * from qpsjobqueue where jobname COLLATE Latin1_General_CS_AS like 'First%'

or

select * from qpsjobqueue where jobname COLLATE Latin1_General_CS_AS = 'FirstTest'