SELECT * FROM catalogo ;
WHERE NOT( alltrim(cod_cuenta) == "1" )
SELECT * FROM catalogo ;
WHERE cod_cuenta <> PADR("1",20)
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 ==.
--sb--