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#')
If I enter Eisen into the search field, it should return one record if SOUNDEX is working right. However, it doesn't return any records. If I hard code Eisen into the search query like this (instead of the variable): WHERE SOUNDEX(hsname) = SOUNDEX('Eisen') SOUNDEX works as it should. Is there a problem with my SQL syntax? Or does it not work with variables? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]