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 >>