msteffens
ADSM.ORG Member
Hello,
Does anyone know how to format a numeric field with commas? My sql statement returns the number, but without commas. Here's my statement:
cast(sum(bytes/1024/1024) as decimal(18,0)) as "MB Transferred"
Looks like this: xxxxxx
I want it like this: xxx,xxx
I can't find any documentation on how to do it and I found nothing in the Forums.
Thanks in advance for any information!
Marty
Does anyone know how to format a numeric field with commas? My sql statement returns the number, but without commas. Here's my statement:
cast(sum(bytes/1024/1024) as decimal(18,0)) as "MB Transferred"
Looks like this: xxxxxx
I want it like this: xxx,xxx
I can't find any documentation on how to do it and I found nothing in the Forums.
Thanks in advance for any information!
Marty