SubSonic Forums
All Your Database Are Belong To Us

Using SOUNDEX (or any function)

Latest post 10-17-2008 7:30 AM by mzk. 1 replies.
  • 10-16-2008 12:25 PM

    • mzk
    • Not Ranked
    • Joined on 10-16-2008
    • Posts 2

    Using SOUNDEX (or any function)

    Can anyone tell me how to achieve the following in SubSonic 2.1?

    SELECT f1,f2 FROM t1 WHERE SOUNDEX(f4) = SOUNDEX('some expression')

    I've tried:

    ...Where("soundex(f4)").IsEqualTo("soundex('bla bla')")...

    but it looks like SubSonic is trying to parse the IsEqualTo parameter

     

    Any help would be appreciated

     

     

    Filed under: , ,
  • 10-17-2008 7:30 AM In reply to

    • mzk
    • Not Ranked
    • Joined on 10-16-2008
    • Posts 2

    Re: Using SOUNDEX (or any function)

    Reply |Contact |Answer

    OK - solved this using an inline query!

Page 1 of 1 (2 items) | RSS