Sunday 15 May 2011

case - Expression to Exclude rows that have a specific column blank -


I want to exclude the entire row with spaces for a specific column .... do not show me that line First name column as blank ... I was wondering if a case statement would help in this case when the [first name] = empty = ????

If it is SQL, normally you can do this:

  SELECT * myTable WHERE is not with myCOLNULL    

No comments:

Post a Comment