varchar comparison in SQL Server
- by Ram
I am looking for some SQL varchar comparison function like C# string.compare (we can ignore case for now, should return zero when the character expression are same and a non zero expression when they are different)
Basically I have some alphanumeric column in one table which needs to be verified in another table.
I cannot do select A.col1 -…