How to display data from table where data is filled in sql server 2005

Hello i want to show data from table where i have to show only that data that column contain some value . i don't want to show null value column of the employee . here i am try to show only that v开发者_运维百科alue that employee field in his details not blank column in his data . can any one help me that how to write query in sql server 2005 .

well, I'm not sure what your table looks like, but something like this should get you started:

select e.details
from dbo.employee e
where e.details is not null 
and e.details <> ''

The syntax is:

select COL_NANE from TAB_NAME WHERE CONDITION

if your CONDITION is COL_NAME is not empty/not blank this mean as Brett wrote:

COL_NAME <> '' or COL_NAME is not NULL