Hi

You could use the convert function to change it to a character datatype:

From the subject "CAST and CONVERT" in Books Online:

In the following table, the column on the left represents the style value

for money or smallmoney conversion to character data.

Value Output

0 (default) No commas every three digits to the left of the decimal

point, and two digits to the right of the decimal point; for example,

4235.98.

1 Commas every three digits to the left of the decimal point, and two

digits to the right of the decimal point; for example, 3,510.92.

2 No commas every three digits to the left of the decimal point, and

four digits to the right of the decimal point; for example, 4235.9819.

John

"sympatico" <com> wrote in message

news:9ZcZa.5774$bellglobal.com...

it

2.50

took

## Bookmarks