It's difficult to understand exactly what you are trying to do from
Quote:
Condition - If Column A(data type-Float) is Negative then Put -1 Sign in Column B and vice versa
The code you already have is putting a
value in ColumnB and appears to work, but you have referred to a "sign".
So if ColumnB is a char type then you appear to want
update v_table1 set ColumnB= case when Isnull(ColumnA,0) <0 then '-' when Isnull(ColumnA,0) >0 then '1' else '0' end
Note I took out your null.
But, if what you really want is to negate ColumnB based on the value of ColumnA then you want something like this
update v_table1 set ColumnB= case when Isnull(ColumnA,0) <0 then -1 * ColumnB when Isnull(ColumnA,0) >0 then ColumnB else 0 end
Note this will only work if ColumnB is not already negative.
If this is not quite what you were asking then use the "Have a Question or Comment?" link next to this solution and I will try to help further