how to check " is not null condition" in a field of single select query

[anushh]

how to check "is not null condition" in a field of single select query

[WoutL]

select *
from table
where column is not null

Wout Louwers

[anushh]

Thanks for your reply. but i didn't mention like this. There is any possibilities to check the field as not null that which is to be selected using select query (not in where condition)

[WoutL]

You can use select IsNull(Column, 'Value') from table. But I am not sure if this is what you mean.

Wout Louwers

[Blue_Boy]

select isnull(column,'N/A') from tablename where column='condition' Hope this will help you.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com