Subject | Re: Another one |
---|---|
Author | Roman Rokytskyy |
Post date | 2004-05-27T12:49:59Z |
> IsnĀ“t possible to execute a query like this using Jaybird?Correct sql would be
>
> nome = "MA";
> sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE "+nome+"%";
sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE '"+nome+"%'";
(note single quotes wrapping LIKE value)
Roman