• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

see how different two columns are

is there a similarity percentage comparing 2 varchar columns
0
rgb192
Asked:
rgb192
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
Anthony PerkinsCommented:
There are a couple of options using T-SQL:
HASHBYTES() and CHECKSUM()
Both have their Pros and Cons.
0
 
rgb192Author Commented:
thanks for the sql server articles

and the hashbytes and checksum similarities
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now