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.