|
jayram
Starting Member
27 Posts |
 Posted - 02/22/2013 : 15:54:01
|
Hello
I have a table with 7 columns like Cumulative_cnt, AX1, AX2, AX3, AX4, AX5, POS
i want to find the first AX column with a 'null' and assign that column number to POS as a value
for e.g. if AX3 has the first null value then POS is assigned a value 3.
table is as follows
AX1-AX5 are varchar
all columns after the first column with a Null is Null
all columns preceding the first column with Null has a value
at least one column has a value and is not null usually AX1 |
|
how to determine the first column with null value
