sql query

[rds747]

Table has two columns. I don't want to display columns that have an empty string.

Select * From Program Where Location <> "" Or Description <> ""

Something like that.

Thanks.

 

[jbenson001]

A result set is based on rows not columns. So with that code, if either of the columns has a NON blank result, the row will still show. Not exactly clear on what you want.

 

[AlexCuse]

rds-

You need to use AND instead of OR to prevent the blank strings from getting displayed.

Select Location, Description
From Program
Where Location <> "" AND Description <> ""

HTH,

Alex

 

[AlexCuse]

*prevent the rows containing a blank string from being displayed