Removing or deleting hyphens

[longbillduck]

I have a field that has information like this:
MPN-B-AB184-9M

I want the field to show up without the hyphens:
MPNBAB1849M

Is there some what this can be done?

Thanks

Art

 

[GingerR]

Check out the REPLACE() function

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[longbillduck]

Thank you, works perfectly