Thanks, I will try

>

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
>

>
>>IF i make a select like this:
>>SELECT * FROM catalogo WHERE alltrim(cod_cuenta) <> "1"
>>Ignore all records that begin with "1", is there a way to ignore only record where cod_cuenta = "1". I want to make a exact search like when using ==.