Replacement of characters within a field

[RTKarkivi]

Hi,

is there a possibility of replacing order of the characters within a field, for ex: 11-22-33 to be like 33-22-11


Thanks in advance,
Hysen

 

[jrbarnett]

Yes - you can use an Update query together with Mid$ to extract parts of the data to update the position. In your example above, the SQL code would be:

Update table set field=Mid$(Field,7,2) & "-" & Mid$(Field,4,2) & "-" & Mid$(Field,1,2)

Messy, but it works.

John

 

[RTKarkivi]

Thanks jrbarnett