Re: [MS_AccessPros] Append characters to a field

 

Art-

UPDATE MyTable

SET Address = "PO Box " & Address

WHERE Address Not Like "HC%"

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Jan 19, 2015, at 10:15 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I need to append the words PO Box to the field Address. But the data in the field is as follows:

122

112

1122

HC 3 Box 25

HC 3 Box 13

432

443

223

HC3 Box 123

I need to append the words PO Box to the data that does not start with HC. Any ideas?

Thank you

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___