That works. It never occurred to me to remove the as. Thanks!!
-----Original Message----- From: Ben A Greenberg [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 8:56 AM To: Sprenz, Marty; [email protected] Subject: RE: MI-L RE: Alias Field Names In a MI Query Try this: Select fldValue1 "fldThisNewFieldName" Where fldValue1 > 1 Into tblNewTableName Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: Sprenz, Marty [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 8:59 AM To: [email protected] Subject: MI-L RE: Alias Field Names In a MI Query Hello, I am trying to create a query that has, I believe it's called, alias field names. Example: Select fldValue1 as fldThisNewFieldName Where fldValue1 > 1 Into tblNewTableName Just so I'm clear, the result of the query would be a new table named tblNewTableName with one field called fldThisNewFieldName with all the values being greater than 1. MapInfo gives me an error that says: Variable or Field Not Defined. Found [fldThisNewFieldName] while searching for [from]. This has me absolutely stumped. I've searched every archive I could and could not find a resolution to what I'm doing wrong. Could you please forward your response to the e-mail address below? Thank you very much for taking the time to look at this. Marty Sprenz (RF Engineer - Contractor) 100 Concourse Pkwy Birmingham, AL 35244 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Office: 205-444-3572 Mobile: 404-509-9820
