Use MD5 Hash
SELECT HashBytes('MD5', a.text1+
a.Text2+
a.Text3
)
compare the concated value's md5 hash to new concarted md5 hash for faster comparison
Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
No comments:
Post a Comment