Hi Alan I'm pretty sure you should be able to use $RString and $LString (think that's what they're called) in an SQL search and field create.
Cheers Dan Bowles -----Original Message----- From: Alan Gunn [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 February 2005 10:24 AM To: Mapinfo-L Subject: MI-L seperate column Hello all, I would like to make a column that is the second half of another column. For example, I would like to remove the number part of an address field, to make a column that is just the street name. So what's the easy way to do this off the tops of your heads? Thanks, Alan --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15151
