Does Derby support soundex

[Danny Yuan]

Hi,

May I know if Derby support soundex? I ran some query like "select 
mytable where soundex(mytable.field) = soundex('a')", and got error 
message SQL Exception: 'SOUNDEX' is not recognized as a function or 
procedure. However, if I remember correctly, previous versions of 
cloudscape supported soundex. If Derby does support soundex, do I need 
to configure something before soundex can be recognized as a function or 
procedure by Derby? Thanks.


Regards,

Danny