functions

[rathnam_qv]

Hi all,

i hv ABC field which has values like  0001.00,0002.00

but i want to remove decimal from that number like 000100,000200

can any one help

Thanks in advance!!!!

Smiley

[tresesco]

Use PurgeChar() like:

=PurgeChar('0001.00,0002.00', '.')

Or,

Load

              PurgeChar(YourField, '.') as NewField   

[#3]

Try This

Replace(fieldname,'.','') as Fieldname

if you need any thing more please find the attachment