I have to format numbers in the column as comma separated.
1000 should be 1,000
1234567 should be 1,234,567
BTEQ -- Enter your SQL request or BTEQ command:
SELECT CAST(123456789.00 AS FORMAT 'G999999999D99');
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
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 !!!