replace chars

J

js

Hi, how to do a search('%,02%') and replace it with ,2005 :
update tb1 set field1=?? where field1 like ??
 
J

John Vinson

Hi, how to do a search('%,02%') and replace it with ,2005 :
update tb1 set field1=?? where field1 like ??
Click to expand...

Depends on your version of Access. The Replace() function was
introduced in A2000, and made available in Queries in 2002 (and, I
believe, in some recent A2000 service packs).

If you're using ADO (as it appears from the %; JET uses * as a
wildcard) try a query like

UPDATE yourtable
SET field1 = Replace([field1], ",02", ",2005")
WHERE field1 LIKE "%,02%";

John W. Vinson[MVP]
 
Top