> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
