How to remove thousand separator from a numeric field?

Database
K_Y
Enthusiast

How to remove thousand separator from a numeric field?

Hi

 

How can we remove thousand separator from a numeric field ?

 

I have a filed which contains value like 234,56,78, while selecting I want to display the data as 2345678. How can it be achieved?

 

Thanks in advance !!!


Accepted Solutions
Teradata Employee

Re: How to remove thousand separator from a numeric field?

That's basically it :

 

select numx (format '999999999') 

from ...

 

Are you using a tool that has a setting to format numerics with commas? That could be overriding this output

 

dave

1 ACCEPTED SOLUTION
5 REPLIES
Teradata Employee

Re: How to remove thousand separator from a numeric field?

Format '9999999999'

K_Y
Enthusiast

Re: How to remove thousand separator from a numeric field?

Hi David

 

Can you write an example, beacuse i can see comma in my result even with Format '9999999999'.

Teradata Employee

Re: How to remove thousand separator from a numeric field?

That's basically it :

 

select numx (format '999999999') 

from ...

 

Are you using a tool that has a setting to format numerics with commas? That could be overriding this output

 

dave

K_Y
Enthusiast

Re: How to remove thousand separator from a numeric field?

I guess so, because I queried with same syntax, still it displayes commas, where can I change this setting in teradata sql assistant 14?

K_Y
Enthusiast

Re: How to remove thousand separator from a numeric field?

Thank you so much David, i removed the setting and it worked.