Mike - This should work: Update TABLENAME set COLUMNNAME = Right$(COLUMNNAME, Len(COLUMNNAME) - 3) Type that in the MB window, substituting in your column and table names appropriately. -Tim Nuteson Dayton Hudson Corporation [EMAIL PROTECTED] ------------------( Forwarded letter 1 follows )-------------------- Date: Fri Dec 10 08:35:38 1999 To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Subject: MI Deleting characters from the left? I have a MI table that has lots of "undesired" text in the first three spaces of a column. The column also varies in text size. Is there a way to delete the first three characters in this column? Thanks. --------------------- Mike Kallas Sprint Corporation Broadband Local Networks Deployment Planning Support Network Analyst III Office: 913.906.7704 Pager: 1.800.724.3329 PIN 3827193 ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
