The other way is to use a query like this..

select * from yourtable where yourcolumn collate sql_latin1_general_cp1_ci_as = 'columnvalue'

That will turn off case sensitivity when running the query.