Implied decimal places

[mwa]

I have a table that contains a field called transaction_amt. It is defined as a varchar(13). The data in this field is right justified and numeric with an implied decimal place of 2.
Example:
transaction_amt
12345
234567

These entries should be 123.45 and 2345.67. I'm taking these values and inserting them into a field in another table that is defined as money. Is there a function that can be used to convert these over to the correct decimal places? Or should I just use the substring function and slam a . in there?

mwa
<><

 

[SQLBill]

SELECT CAST(transaction_amt AS MONEY)

or

SELECT CONVERT(MONEY, transaction_amt)


Refer to the Books OnLine for CAST and CONVERT

-SQLBill

 

[bdreed35]

SQLBILL:

Your solution doesn't deal with the implied decimal palce.

mwa:
Try this:

SELECT (CONVERT(money, '12345'))/100

~Brian

 

[mwa]

Oh right... Use a little 4th grade math... Why didn't I think of that? Must be time for some more Mt. Dew...

Thanks bdreed35...

mwa
<><