Strip Some Characters from Numbers

[Moore71]

Hi,
I have some numbers like this: (EE:39:F:BA:63:BF), how can I strip-off the colon from off this numbers, leaving it like this (EE39DFBA63BF) programmatically? This number is stored in table and I want to stripe the colon off, and let it be just an ordinary text
Thank you

 

[June7]

Replace([fieldname],";","")

That expression can be used in query or in textbox.

 

[Moore71]

Thanks for your quick response. I sure hope this gonna work, without doubt.

Thank you

 

[June7]

Uncle Gizmo, why do you recommend a custom function? Why another layer of processing?