Auto Replace Text in a table
Is there a statement I can add that will automatically replace a text string with another string? EX> NORTH CHANGE TO BILLY BOB THROUGH OUT A FIELD
Software/Hardware used:
MICROSOFT ACCESS 2003
Software/Hardware used:
MICROSOFT ACCESS 2003
ASKED:
May 4, 2010 6:01 PM
UPDATED:
May 4, 2010 6:42 PM
Answer Wiki:
That would be the <a href="http://www.techonthenet.com/access/functions/string/replace.php">Replace Function</a>
If you want to use it in a SQL UPDATE command, it would be something like this:
<pre>UPDATE your_table
SET your_field = REPLACE(your_field,"NORTH","BILLY BOB")
WHERE <conditions></pre>
-----------------
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
