At the moment, I’m brushing up a bit on my SQL knowledge. It’s paper-thin and building reports in Reporting Services does require a pretty decent bag of tricks.
The latest trick I learned is Soundex.
select firstname, LastName, SOUNDEX(lastname)
where SOUNDEX(lastname) = SOUNDEX('Brown')
There you have it, the Soundex function is able to find names in a database that sound the same.
In this case, SQL will come back with names like : Brown, Brian and Bruno.
Nifty.. really nifty