yartax1 wrote:

> 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

For performance reasons ( as Ann has hinted ) I would suggest that you
create extra columns in the tables, which have the sub string values
filled in via a trigger. I use something similar to store the parts of a
UK postcode entry so I can find postal areas easily.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services