--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@B...> wrote:

>
> > No. I asked "Do you mean _input_ parameters, passed via _xsqlda
> structure_
> > ?"
> > So, can you execute this:
> >
> > select
> > f_left( ?, 2)
> > from rdb$Database;
>
> To be honest, I don't recall ever trying this. This would not fit into
> the normal pattern we would use for input parameters from a Delphi App.

How about this? Don't you think it is a possible pattern?
Does it work in your environment?

select * from table1
where
f_left(table1.field, 2) = f_left(:param1, 2)