river1
SSC-Insane
Points: 24315
More actions
May 9, 2011 at 8:46 am
#389479
Hi,
I need to replace the value 0 to varchar 'WithOutData' but only if the value is 0.
I.E - If value = 0 the 'WithOutData'
If value =2000 the 2000
How can i do this?
Thank you
John Mitchell-245523
SSC Guru
Points: 148809
May 9, 2011 at 8:54 am
#1321761
What is the data type of your column? It would help if you could provide table DDL and sample data in the form of INSERT statements.
John
May 9, 2011 at 8:57 am
#1321766
data type = float
May 9, 2011 at 8:58 am
#1321767
data:
0
200
100
20
700
....
May 9, 2011 at 9:00 am
#1321768
If data type is float, you can't put string data in it.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply