Error converting data type varchar to numeric

Question

I have this part of query that causes the above error:

CONVERT(varchar(15),CAST((AmountOfInsurance) as MONEY),1)

What am I doing worng?

This is the declararion of AmountOfInsurance

AmountOfInsurance decimal(19,2),

Error message pretty clear. You cannot convert non numeric characters to money. AmountOfInsurance has some non numeric characters — Pரதீப்
– Pரதீப், Commented Feb 2, 2017 at 7:08
can you please post the whole query, from query you are fetching varchar and on code side you have assigned numeric so you are getting above error — Chintan Udeshi
– Chintan Udeshi, Commented Feb 2, 2017 at 7:09
there is non decimal value as AmountOfInsurance .if AmountOfInsurance is decimal or its is null also work fine . — Ronak Patel
– Ronak Patel, Commented Feb 2, 2017 at 7:11

marc_s · Accepted Answer · 2017-02-02 07:22:15Z

1

I hope this will work for you...

CONVERT(varchar(15), CONVERT(money, AmountOfInsurance), 1)

More information: the last parameter decides what the output format looks like:

0 (default) No commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 4235.98.
1 Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92.
2 No commas every three digits to the left of the decimal point, and four digits to the right of the decimal point; for example, 4235.9819.

If you want to truncate the pennies, and count in pounds, you can use rounding to the nearest pound, floor to the lowest whole pound, or ceiling to round up the pounds

edited Feb 2, 2017 at 7:22

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Feb 2, 2017 at 7:15

Darshak

8677 silver badges18 bronze badges

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

4 Comments

mplungjan Over a year ago

This is plagiarism. Please do NOT copy word for word from other answers but instead comment that they are duplicates.

Bhargav Rao Over a year ago

@mplungjan, Lots of posts mention that stackoverflow.com/… .... Looks like it is all plagiarized from a single source.

mplungjan Over a year ago

This is the second copy of a post I have seen from this user

Darshak Over a year ago

@mplungjan i accept my apology for that..now onwards i will take care this things..

Collectives™ on Stack Overflow

Error converting data type varchar to numeric

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related