newbie sql question

[sezme]

I have a select statement

Select dbID, dbName From dbTable

what i want to do is only dbName when it has a value
ie when it is not empty

I have tried

Select dbID, dbName From dbTable Where dbName Is Not Null

but no success

thanks in advance

 

[JamesLean]

Your query looks fine to me. I can only imagine your "empty" values are actually zero-length strings. Try:

Select dbID, dbName From dbTable Where dbName = ''

--James

 

[sezme]

that works - thanks