Mass update when data contains "-" 2

[chris3942]

We have a table with a column labeled "Model". In many of the records the "Model" contains a "-" (ie: -345). I need to change every model that is proceeded with a dash to
that model followed with "-REPAIR". In other words if the record shows the data as "-345" I'd like to update it to show as "345-REPAIR". I need help handling the dashes in the Update Query.

 

[TomCologne]

Put this in the Update field:

IIf(Left(Trim([Model]),1)=Chr(45),Mid(Trim([Model]),2,Len([Model])-1) & Chr(45) & "Repair",[Model])

TomCologne

 

[PHV]

UPDATE yourTable SET Model=Trim(Mid([Model],2)) & "-REPAIR"
WHERE Model Like '-*';

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244