SELECT * FROM catalogo ; WHERE NOT( alltrim(cod_cuenta) == "1" ) * or even better SELECT * FROM catalogo ; WHERE cod_cuenta <> PADR("1",20) * or SELECT * FROM catalogo ; WHERE cod_cuenta <> PADR("1", LEN(cod_cuenta))SET ANSI ON would work too.
>I have a table with this records: >cod_cuenta (c(20)) Nombre_cuenta (c(50)) >1 ACTIVOS >10 ACTIVOS CORRIENTES >11 OTROS ACTIVOS >2 PASIVO >3 CAPITAL>