<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	SQL Server Text Matching Is Case INSENSITIVE
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:723.view
	
	Date Posted:
	May 23, 2007 at 12:33 PM
	
---- --------------------------------------------------------------------------------------- --->


SELECT
	id
FROM
	address
WHERE
	street1 = '123 Street St'
 
 
SELECT
	id
FROM
	address
WHERE
	street1 = '123 STREET ST'
 
 
SELECT
	id
FROM
	address
WHERE
	street1 = '123 StReEt sT'