Hi............
one table is there with no of column, like emp, age,sal,DOB etc,
so How can I read content of Age is null or some number present,so my intension is
if content of Particular column in a particular Row is not null,i pick that column,and create word template with same column name(empty word template),example emp column have name, this column,present in template Header column,i hope u understand.
Please help me for this ........
thanks in Advance............
Loading
Anil KumarPosted May 21, 2012, 1:48 AM
FROM
WHERE age IS NOT NULL
Kunal VaishyaPosted May 21, 2012, 1:21 AM
use this is require
Select age From TableName Where age!= 0 And age!= IsNull(null,0)
you will get 0 age records
Krishna GaradPosted May 21, 2012, 1:15 AM
select age from TableName Where age!= null