Exactly what I was looking for and worked perfectly, thanks Tim
GH -----Original Message----- From: Tim.Nuteson [mailto:[EMAIL PROTECTED] Sent: March 12, 2004 16:53 To: Gilbert Hach� Subject: RE: MI-L update 2 columns from one columns Gilbert, Stateabbreviation = Right$(COLUMN, 2) Cityname = Left$(COLUMN, instr(1, COLUMN, ",") -1) Tim Nuteson Target -----Original Message----- From: Gilbert Hach� [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 3:50 PM To: [EMAIL PROTECTED] Subject: MI-L update 2 columns from one columns I have a table, a single column with both Cityname and Stateabbreviation in this format: Cityname, Stateabbreviation or if you prefer: Miami, FL I want to separate this column in two separte columns. Easy enough to update the Stateabbreviation using the Right$(,2) command but what about the Cityname part? I'm sure to have seen it before put couldn't put my hands on it in the archive something about using the "," as a delimiter... Gilbert Hach� Solutions Consortech Inc. 6300, Auteuil, Bureau 505 Brossard, Qu�bec, Canada, J4Z 3P2 T�l/Tel. : (450) 676-1555 Ext. 211 T�l�copieur/fax : (450) 676-8851 Courriel/email: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10850
