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

Update YourTable
set POS = 
case 
	when AX1 is not null then 1
	when AX2 is not null then 2
	when AX3 is not null then 3
	when AX4 is not null then 4
	when AX5 is not null then 5
end

MadRazzi (2/22/2013)

---

what if ax2 through ax5 is null for a record

wouldn't the case statement assign value 5 to POS?