soundex

[bogdani]

could soundex accept numeral strings as parameters? (like '1234')?

thanks

 

[harebrain]

Probably not. It doesn't make sense if you consider the purpose of SOUNDEX. But why don't you consult the documentation for the implementation you're using? Why don't you just try it and see what happens?

 

[bogdani]

I use sybase and sql server, but this issue is not deal with. Of course the function makes sense only if is used whith alfa strings, but I want a link to a written doc.

thanks a lot for your response

 

[harebrain]

From MSDN:

SQL Server: "The SOUNDEX function converts a character string to a four-digit code for use in a comparison. Vowels are ignored in the comparison. Nonalphabetic characters are used to terminate the comparison." (emphasis added)

For the documentation, see

http://msdn.microsoft.com/library/en-us/acdata/ac_8_con_11_1rj9.asp