How to convert values in SQL

Question

I'm trying to convert the values from the column Debit; if the values is blank it should convert to 0 otherwise it should convert the value to a decimal.

Here's what I've done so far:

  CONVERT(Decimal(18, 2), (CASE Debit WHEN ' ' THEN 0 END)

It works, but I want to retain the value if its not a blank. How would I do that?

try this CONVERT(Decimal(18, 2), REPLACE(Debit, ' ', '0')) suggested by ahillier88 — Arijit Mukherjee
– Arijit Mukherjee, Commented Jun 10, 2014 at 10:43

user3410433 · Accepted Answer · 2014-06-10 10:42:18Z

2

Something like this?

CONVERT(Decimal(18, 2), REPLACE(Debit, ' ', '0'))

answered Jun 10, 2014 at 10:42

user3410433

Sign up to request clarification or add additional context in comments.

1 Comment

user3211476 Over a year ago

yeah..something like that..tnx buddy

Collectives™ on Stack Overflow

How to convert values in SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related