I have a view that contains nulls in a column when there is no data. I am calling the view from an ASP page with a select statement and a where clause that specifies the selection of records that match a text string. The query returns all the records that match the string, but also all nulls as well. I tried the "IS NOT NULL" statement but all records with nulls in the field are still returned.
What do I need to do to pull all records that match a string from a view, without the records that have a null in that field?
Scott
What do I need to do to pull all records that match a string from a view, without the records that have a null in that field?
Scott