Using an update query to change part of a field 1

[bravo6]

Can an update query be used to change a portion of text within a record?

I have a field that is populated by numerous records that contain the string "//" eg CCCC//CCNN.CCC

I want to write an update query that will select fields that contain the "//" and change the "//" to "@". So in the above example the result would be CCCC@CCNN.CCC

Thanks to everyone who has been so helpful in the past.

PLEASE no VBA answers, I need this in Access.

 

[traingamer]

Use Replace().


Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[traingamer]

e.g.

Update yourTable
set yourfield = replace([yourfield], "//", "@")

Hit return too quickly.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard