how to divide one column to two columns

hi friends,

i have one table is normal column is bit

id isnormal

1 0
2 0
3 0
4 1
5 1
6 0
7 1

i wnat oput put like this

id normal abnormal
1 0 1
2 0 1
3 0 1
4 1 0
5 1 0
6 0 1
7 1 0

note:–where isnormal is 0 that time i wnat to display 1 in abnormal column
where isnormal is 1 that time i wnat to display 1 in normal column
first i want to divide is normal column into two columns one is
norman
second one is
abnormal

please help me it’s very urgent in my project

Thanks & Regards’
PrasadGopathi

re: how to divide one column to two columns

So, what have you got so far?

Steven