string manipulation 1

[neilmcmor]

I have a field in a table that contains postal codes in the uk in the form ab39 9. I would like to be able to trim the space from the record so it reads ab393. The space is not always the fourth character though. Any ideas?

 

[genomon]

Yup - Replace(fieldname, " ","")

Did you hear about the Buddhist who refused Novocain during a root
canal? He wanted to transcend dental medication.

 

[neilmcmor]

Thanks genomon.