This might be a really stupid question but can anyone explain to me exactly how the soundex() function arrives at the 4 character values that it produces?

The first character seems to always be the first character of the string that you pass into it.

How does it come up with the other three?

Phil.