Access find and replace? 1

[brownfox]

Does anyone know if Access sql has a replace function? In mySQL it's this:

UPDATE myTable SET myColumn = REPLACE(myColumn, 'toBeReplaced', 'newValue');

 

[dhookom]

Most later versions of Access allow you to use the Replace() function in queries. I believe Access 2000 required you to wrap the Replace() function in your own function with the same functionality.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[PaulF]

ACCESS has an "Update" Action Query that does that.

PaulF

 

[PHV]

The standard SQL way:
UPDATE myTable SET myColumn = 'newValue' WHERE myColumn = 'toBeReplaced';

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

 

[brownfox]

Thanks for the help. PHV that is exactly what I wanted.