sql query

[ggalan]

is it possible to query a column that has some value? in other words if the value is blank then dont choose

SELECT * FROM tableName WHERE descript1 NOT LIKE ' ';

so i want to choose all items from descript1 that have some sort of value

[Schmoopy]

SELECT * FROM tableName WHERE descript1 IS NOT NULL AND descript1 != ''

Should do the trick.