Help with query

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sanmatrix SSC Veteran Points: 250 More actions · Answer 1

Yes there are functions in sql which does this. i don't remember the exact name but they are like soundex and similar try soundex

dheer Ten Centuries Points: 1275 More actions · Answer 2

Is it possbile to use this function to join two tables .I mean joining on Fname by using soundex function

AK1516 SSCrazy Points: 2705 More actions · Answer 3

try putting an full text index on the tables and here are some commands for the comparison.

sanmatrix SSC Veteran Points: 250 More actions · Answer 4

probably yes. something like soundex(t1.fname)=soundex(t2.fname)

Derrick Smith SSChampion Points: 10833 More actions · Answer 5

It sounds like you could use DIFFERENCE()

Doing something like:

select difference('ROBERT','ROBART')

Returns 4, which means they are very similar

Whereas executing:

select difference('ROBERT','ROGER')

Returns 2, which means little similarity

And executing:

select difference('ROBERT','JASON')

Returns 0, which is nothing in common at all.