Formate the Decimal

hhhhhhhqat

there's one field the current format is ( 1,000.00) , what the format of this data type to give me output ( 1000.00) without group decimal(,)

thanks

imclever1205

Try puting Format before the field value.e.g format(field);

Yaroslav_Gaponov

FORMAT(dec,0,9); // xml format

kine

Better FORMAT(value,0,2) - it will remove the thousand separator, but will preserve decimal point character (which could be , or ., format 9 will use . each time).