SQL Table query

[atuljadhavnetafim]

Dear Expert

i have one table "AR" in SQL Server, and in that table one column is there named "Arrear"
this column contain positive and negative numner like
123, 43, 54, 0, -34, -56, -678
now i want to bifurcate this number in category like
if the bumber >=0 then category will be "OD"
if the number <0 then category will be "FD"
i have one blank extra column in my data base, or we can create new column with above condition

but how

please help me

 

[atuljadhavnetafim]

What part are you not clear about? Can you post the SQL you used to create the view?

i am still not clear how to update OD_FD column based on another column, please explain in detail step by step
and SQL forum not replying on this

 

[FormR]

i am still not clear how to update OD_FD column based on another column, please explain in detail step by step
and SQL forum not replying on this

If you want to add the column to your view, then can you post the SQL that was used to create the view? You need to have a grasp of some of the basics for this, it is not going to be practical to walk through every step.