I have a datatable in a SQL Server 2008 DB that contains "Unit of Measurement" abbreviations. In some cases there are 2 abbreviations with the same characters, however they mean different things. Here is an example:
Is there a way to make a comparison in SQL Server that can treat each value differently. My problem is that I'm returning 2 rows instead of 1.