Replace character in a string

[razorking]

Another easy one I am sure:

How do I replace a character in a string? For example I have values in a field like:
12345
123-45
12-345

And I want to remove the dashes. What is the easiest way to do this in a query

 

[HiTechCoach]

Assuming you have Access 2000 or later,

use the Replace() function

 

[rockyjr]

You may want to take a look at this. May help you in the future.

http://www.datapigtechnologies.com/flashfiles/instrfunction.html

 

[DCrake]

I took a look at that and it took me all of 1 second to see how amateurish the solution was.

The easiest method, as previously mentioned is the Replace() function

Replace([Name],"-","")
Replace([Name]," ","")

David

 

[razorking]

Yeah, the replace function works fine. Thanks!

 

[HiTechCoach]

You're welcome!

Glad we could assist.