Hi Christine In supplement to Uffes answer you could also use this:
Str$(Val(YourField)) in and update column statement or even in a SQL query like this: Table1.YourField1=Str$(Val(Table2.YourField2)) This will permanently or temporarily remove the "00"m problem. Regards Thomas Brix Lyng Frederikshavn Municipal Administration Denmark -----Oprindelig meddelelse----- Fra: Ronning, Christine [mailto:[EMAIL PROTECTED] Sendt: 5. april 2005 17:50 Til: mapinfo-l@lists.directionsmag.com Emne: MI-L Removing 0's I know there has to be an easy way to do this, but I can't figure it out right now. I have a field I want to join two tables on, but on of the tables has 00 infront of each number. Ex want to join one field (value =1) and other field (value = 001). Does anyone know the syntax to removes these 0's? Thanks, Christine Ronning GIS Technician 740 Carmi Avenue Penticton, BC V2A 8P9 250-770-3408/250-870-4677 [EMAIL PROTECTED] -----Original Message----- From: Kristof Vydt [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 4:11 AM To: mapinfo-l@lists.directionsmag.com Subject: MI-L Store query with "Within" in workspace I read that queries are only stored correctly in a workspace, when using "Run Command" instead of using SQL directly. Currently, I use ... Select * From BaseLayer Where obj Within ClipRegion Into ResultSet .. as some kind of clipping my BaseLayer. But this query is not correctly saved to the workspace. Any idea how to rewrite this query using "Run Command" ? Kristof Vydt Send instant messages to your online friends http://uk.messenger.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15948 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 15954