• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

SQL query filter criteria for all but blank

I have a query in which I have a column that has some blank records. I want filter out all of the records with blank values. what criteria do I use to apply this?
0
Bill Warren
Asked:
Bill Warren
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
WHERE urColumn <> ''
 or urColumn is not null
0
 
Bill WarrenIT ManagerAuthor Commented:
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now