Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 string function

Author  Topic 

bedi_rsb@yahoo.co.in
Starting Member

1 Post

Posted - 2008-07-05 : 09:56:55
plz tell me the use and working of difference() string fuction

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-05 : 12:20:31
difference() is using the results of soundex() for the two given strings and compares them.
It returns 0 to 4 as result.
4 is the best and 0 is the worst result.
So you can compare strings without having the need of total matching.

Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...
Go to Top of Page
   

- Advertisement -