Soundex and invalid sound check

Question

Is it possible to verify that SQL returns Soundex 0000 based on the assumption that this is an incorrect word, for example. has numbers, spaces, special characters, or is there a better way to do this?

Answer 1

I don't think soundex is good for this, I think the SOUNDEX () function will skip numbers, spaces and a character, for example:

SELECT SOUNDEX("HELLO")
SELECT SOUNDEX("_HEL123O_")

Both give you the same result.

H400

In addition, SOUNDEX () has a limitation on how it works.

, , , , . .

HTH