>I work in Oracle, so see if there is an equivalent way on SQL Server.
>
>Oracle, like VFP, has a soundex function. So something like --
>
>where soundex(lastname) = soundex('OBrian')
>

Soundex() is available in SQL Server 7.0 too.