Re: [MS_AccessPros] Append characters to a field

 

John,

Perfect. Thank you. 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, January 19, 2015 3:40 PM
Subject: 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: Art Lorenzini <dbalorenzini@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___