is there a simple way to show all the records in a text field that contain a value. i have a field in my table that doesn't require a value but i need to show all the records in that table that do have a value in that field. i'm trying to create a query to show only the records that have values in one paticular field. and its a text field so i cant use a simple <> to filter out a number range.

SELECT ... FROM tablename WHERE fieldname IS NOT NULL