View previous topic :: View next topic |
Author |
Message |
NASCAR9 Intermediate
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
|
Posted: Fri May 28, 2010 12:27 pm Post subject: Something "NEW" to me and Very COOl! |
|
|
select * from YOUR TABLE
WHERE SOUNDEX(LAST_NAME) = SOUNDEX('SMITH');
This query will pull all rows where the LAST_NAME (that DB2 thinks) sound like 'SMITH' _________________ Thanks,
NASCAR9 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|