question

harshita avatar image
harshita asked

conversion null value into numeric

hello All,

I tried to convert null values into numeric or 0.00 but few of the total values rest remained as null. I performed this task by using ISNULL function with proper syntax. can anyone help me regarding this

conditionalisnull
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SANTOSH 2 avatar image
SANTOSH 2 answered

write the query u used to do that.After dat i will help u..ok

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Madhivanan avatar image
Madhivanan answered

Use

ISNULL(col,0.0)            

or

COALESCE(col,0.0)            
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.