Posted by paulmac106 on 02/22/07 18:15

Ok my last formatting question.

How can I insert a money value as a padded string in another table?

example $1.25 gets inserted to another table as 00000125

I want 8 total characters and no decimal

another example would be 4,225.99 becomes 00422599

can this be done?

thank you!!

• Next in forum: Re: Format money value as padded string
• Prev in forum: Re: SQL statement - INSERT INTO and SELECT
• Thread view: Format money value as padded string

[Reply to this message]