Re: Using Soundex

2004-08-22 Thread Chris McKeever
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

Using Soundex

2004-08-22 Thread Debbie Woods
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