Thsnks Yuri, that did the trick. I have never even heard of TRANSFORM() before!
Winn
>?trans(4862363.29,"999,999,999.99")
>
>>Hi All,
>>I have a string that happens to have a dollar amount. The dollar amount is something like 4862363.29-now if I want to put commas as separators, do I have to do a SUBSTR() or is there another way?
>>Thanks,
Winn Pauley