At 01:25 PM 12/2/2004, yartax1 wrote:

>Thanks for the suggestion. Sorry, I'm afraid don't understand the
>trick to pas SP into UDF!

You can't pass a stored procedure into a UDF. However, you can't
use a stored procedure like a UDF either, so your only choice in
this case is to find a UDF that does what you want or write one.
Look on ibphoenix.com for lists of udf libraries. There are a
lot.

>You suggest me to create a UDF like others
>functions, right? To do that, I must create a .dll and create an UDF
>entry point to the function created in that dll! Is that ok?

Right. By the way, I'd worry about the performance of this
query.

> >
> > >Select a.* from no_nomina a
> > > inner join no_contrato b
> > > on a.empleado = b.empleado and
> > > a.orden = b.orden and
> > > a.empresa = b.empresa
> > > inner join usuario_centro c
> > > on sysleft(destcon,2) = sysright(c.centro,2)
> > > where c.idusuario = 1

The comparison that uses the functions sysright and sysleft
won't use indexes. Generally speaking relational theory
discourages the use of things like substring in favor of
atomic values.

Regards,


Ann