By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,163 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

how to divide one column to two columns

P: 1
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
Aug 9 '09 #1
Share this Question
Share on Google+
1 Reply


MrMancunian
Expert 100+
P: 569
So, what have you got so far?

Steven
Aug 10 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.