On Mon, 23 Aug 2004 00:25:36 -0500, Debbie Woods
<[EMAIL PROTECTED]> wrote:
> I am building a search feature with Cold Fusion and need to have similar
> string matches included in the search results. I have a search form field
> called hsname. I am trying to use the SOUNDEX function in my query lik
I am building a search feature with Cold Fusion and need to have similar
string matches included in the search results. I have a search form field
called hsname. I am trying to use the SOUNDEX function in my query like
this:
SELECT *
FROM accounts
WHERE SOUNDEX(hsname) = SOUNDEX('#form.hsname#')
I