Collation Help

[markroberts]

I am currently working on a database where collation settings are set to be Character Case sensitive. This is causing me no end of grief as alot of the data has been entered in lots of different cases.

For example the word Property Expenses could be in 500 times in a table but in 3 different cases, Upper, Proper and Lower.

How can I change my query so it could pick up all the different cases.

My SQL query is

SELECT *
FROM ppms.units
WHERE Unit_Stat = 'Property Expenses'

Many Thanks

Mark

 

[SQLSister]

SELECT *
FROM ppms.units
WHERE Upper(Unit_Stat) = 'PROPERTY EXPENSES'

Don;t use Select * either; it is a bad programming practice. Use only the fields you need.

Questions about posting. See faq183-874

 

[markroberts]

Thanks a lot. I only used the select all as a quick example.