Actually, I have read, that it's advised to use starting with instead of
like (in isql) - can't say why, but there must be some messages in groups
archive
I was wondering, why 'starting with :ParamName' & paramedit isn't working
as supposed

At 2003-11-05 18:55, you wrote:

>1) change 'starting with' to 'like' in sql, e,g
> select s."Sokejo_ID" , s."Vardas" , s."Pavarde"
> from SOKEJAI s
> where
> s."Vardas" like :Vardas
> and
> s."Pavarde" like :Pavarde
>
>2) When vardas or pavarde are null use '%' symbol.
>3) Append '%' symbol to vardas and pavarde params.

--/ Gediminas /--
The Truth Is Out There