Providing a thousand separator for a char column

[asmfloyd]

Hello,
  I have a char column which checks for couple of conditions and need to display results as *, '-',.. If the conditions are not met, I will get an integer result. For this integer result, how can I add
comma as a thousand separator?
  Since the column is coming as a character, declaring the format as number and adding thousand separator option is not working.

Thanks,

[oscarca]

format([Integer];'#,0.00')

if the the Data item/column is a varchar you have to cast it first to a integer. Format(cast([Data item];integer);'#,0.00')

Best regards,
Oscar

[asmfloyd]

Thanks much Oscar for the inputs.

I used the below which I got
  to_char(source,'9G999G999G990') 

Source:

https://www.ibm.com/developerworks/community/forums/html/topic?id=77d3ccf7-3f8e-4144-876d-2f348e7b2bab