|
Home > Archive > MS SQL Server > February 2006 > Reversing a soundex result
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Reversing a soundex result
|
|
| almurph@altavista.com 2006-02-09, 1:23 pm |
| Hi everyone,
Hope you can help me with this one. Given a soundex value like:
"M500" how can you tell what the original value was as a charcter
string? In other words, how can you go back? (inside query analyzer??)
SELECT soundex('help') = H410
but if I was given H410 - how do I determine the string??
Comments/suggestions/code samples much appreciated...
Al
| |
| David Gugick 2006-02-09, 8:23 pm |
| almurph@altavista.com wrote:
> Hi everyone,
>
> Hope you can help me with this one. Given a soundex value like:
> "M500" how can you tell what the original value was as a charcter
> string? In other words, how can you go back? (inside query analyzer??)
>
> SELECT soundex('help') = H410
>
> but if I was given H410 - how do I determine the string??
>
>
> Comments/suggestions/code samples much appreciated...
>
> Al
You can't. It's a one-way algorithm since different character strings
can be represented by the same SOUNDEX value.
What is the problem you are trying to solve?
--
David Gugick - SQL Server MVP
Quest Software
|
|
|
|
|