I have character data (money) that I need to convert to numeric data type.

When I use the convert or cast functions I receive, " Error converting data
type varchar to numeric." error.

I found that the character data contains credits with a negative sign. Does
anyone have a good idea how to convert this to numeric or decimal format?

Is it possible that there are some other characters causing the conversion
error?

A test like SELECT CAST('-34.00' as MONEY) works just fine and returns

-34.0000

Could you post a sample of the data?

Jim

"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote

If you just need to strip out the negative sign, try
something like:
cast(replace(YourTextColumn, '-', '') as decimal(10, 2))

-Sue

On Wed, 16 Feb 2005 10:31:02 -0800, "Gary"
<Gary (AT) discussions (DOT) microsoft.com> wrote:

Thank for your reply Jim.

The negative sign was on the right. Convert and cast only work if the "-"
is on the left.

I did resolve it though. I just moved the "-" from the right to the left
with this:

RIGHT(RTRIM(freight),1) + SUBSTRING(freight,1,len(freight)-1)

Thanks again.


"Jim Young" wrote: