By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,961 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,961 IT Pros & Developers. It's quick & easy.

Replacing Characters in the Field

P: n/a
max
I have a field that has two first names with + in between them.. I'm
trying to run a query to substitute + with & . The update query
doesn't work because it deletes all the data field and puts "&"
instead.
I know I need some code but have no idea how to go about writing it..
Anybody could help? Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use the Replace command to make the replacement a calculated value.

Example:
UPDATE Table1 SET Table1.Field1 = Replace([Table1].[Field1],"+","&");

--
Wayne Morgan
MS Access MVP
"max" <ma*****@yahoo.com> wrote in message
news:70*************************@posting.google.co m...
I have a field that has two first names with + in between them.. I'm
trying to run a query to substitute + with & . The update query
doesn't work because it deletes all the data field and puts "&"
instead.
I know I need some code but have no idea how to go about writing it..
Anybody could help? Thanks

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.