Help with an Update query that finds characters in a string and replaces them

D

Dave

I want to set up an Access query that searches for letters in a string and
replaces those letters.

Can you get me going?

Thanks

==========================

Examples:

search for abcdef and replace with bbb

jsmith.abcdef.com >> jsmith.bbb.com

dsmith.abcdef.com >> dsmith.bbb.net
 
R

Rick Brandt

Dave said:
I want to set up an Access query that searches for letters in a
string and replaces those letters.

Can you get me going?

Thanks

==========================

Examples:

search for abcdef and replace with bbb

jsmith.abcdef.com >> jsmith.bbb.com

dsmith.abcdef.com >> dsmith.bbb.net
Click to expand...

Access has a Replace() function. You would use that in an UPDATE query.

UPDATE TableName
SET FieldName = Replace(FieldName, "abcdef","bbb")
 
D

Dave

Thanks

It works :)

Dave

Rick Brandt said:
Access has a Replace() function. You would use that in an UPDATE query.

UPDATE TableName
SET FieldName = Replace(FieldName, "abcdef","bbb")
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I add to a current update query? Or do I have to make another? 3
Replace or insert characters in text string 6
Changing Data Type of Column in Query. 1
Creating a query that will search for first 3 letters of a postcod 2
Help with a query using wildcards 1
Update Table Field Value with SQL Query 2
Limiting Records in an Update Query 5
Update table with values from another table 2

Top