Remove "-" from a six character field

[amerifax]

I have a field called "SC" with a value 13-251. I need to remove the "-" ending up with 13251. I tried using, as a starting point, Mid(String, Start, Length) with no success. I found this in another topic, and thought this might be close to what I was looking for. I sure did not know how to use it. When I selected the run command I got the following response:

Query must have at least one destination.

I tried a few different things like adding an extra field and different pointers but I doubt if I'm even standing in the batters box.

Bob

 

[Alansidman]

try this:

Expr1: Left([tany],InStr(1,[tany],"-")-1) & Right([tany],Len([tany])-InStr(1,[tany],"-"))

where tany is your field name. Change it to reflect your field name.

 

[Galaxiom]

The simplest expression would be:

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

 

[amerifax]

Thanks to you both.
Bob