| 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