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