Re: Error: searching for customer by address field

["Chris Travers" <..hidden..>]

> OK, two things:
> 1.  why don't you use ILIKE instead of LIKE and you can forget about
> case (and that OR clause that's giving you the error).
> 2.  your problem is in the second "%street%".  Change the double
> quotes to single quotes and the error will go away.

Suggestions noted.  Will be committed shortly.
> Ciao,
>
> David A. Bandel
> --
> Focus on the dream, not the competition.
>             - Nemesis Air Racing Team motto
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel