Escoja la que mas le agrade
Código SQL:
Ver originalSELECT * FROM tabla WHERE campo<>@valor
SELECT * FROM tabla WHERE campo NOT IN (@valor)
SELECT * FROM tabla WHERE campo BETWEEN 0 AND 99.99
SELECT * FROM tabla WHERE campo >0 AND campo<100
SELECT * FROM tabla WHERE NOT EXISTS(SELECT 100.00)