Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use PurgeChar() like:
=PurgeChar('0001.00,0002.00', '.')
Or,
Load
PurgeChar(YourField, '.') as NewField
Try This
Replace(fieldname,'.','') as Fieldname
if you need any thing more please find the attachment