SeaninSeattle
IS-IT--Management
Ok - so this is the last issue - and I swear I'll stop whining...
I have a numeric field that I converted to a decimal field. I need to now convert that decimal field to a varchar or char so that my ASPMail app can pick up the whole string (right now, it only picks up non-zero values - so $5.00 comes out $5, but $5.43 comes out $5.43 - very stupid).
Can anyone stop the rest of my hair from going gray and suggest an easy way to convert decimal to varchar or char with getting the 'arithmatic overflow' error?
Thanks,
//sse
Sean Engle
Admin/DirIS
ssengle@bswusa.com
I have a numeric field that I converted to a decimal field. I need to now convert that decimal field to a varchar or char so that my ASPMail app can pick up the whole string (right now, it only picks up non-zero values - so $5.00 comes out $5, but $5.43 comes out $5.43 - very stupid).
Can anyone stop the rest of my hair from going gray and suggest an easy way to convert decimal to varchar or char with getting the 'arithmatic overflow' error?
Thanks,
//sse
Sean Engle
Admin/DirIS
ssengle@bswusa.com
)' to change DECIMAL to VARCHAR...