Subject Re: Another one
Author Roman Rokytskyy
> IsnĀ“t possible to execute a query like this using Jaybird?
>
> nome = "MA";
> sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE "+nome+"%";

Correct sql would be

sql = "SELECT * FROM CLIENTES cli WHERE FANTASIA LIKE '"+nome+"%'";

(note single quotes wrapping LIKE value)

Roman