MadRazzi (2/22/2013)

---

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 which is usually AX1