Oliver, You can also search for one letter wild cards using the like operator of the SQL selection. Use an underscore (_) where you'd want the letter to sit. For instance if you wanted any letter to be in one part of a string you could put the underscore there.
This search: ID Like "B_x" would result in records with an ID like Box, Bax, B1x, B2x etc. Or ID Like "Bax1_2" would result in something like Bax122 or Bax162 or Bax1B2 or Bax1a2 etc. You can also use multiple underscores if you are looking for something with more than one letter. In both cases each underscore represents one letter. For example: ID Like B__x would be Boox, Baax, Badx, B52x etc. Jennifer McQuiston MBS, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Oliver Sent: Thursday, January 17, 2002 8:16 AM To: 'MapInfo-L (E-mail) Subject: RE: MI-L Thanks all, Are there any other wildcards? Such as more specific ones representing only characters, or only numbers or a wild card that represents only one character? Ollie. -----Original Message----- From: David Booth [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 12:09 To: 'Oliver' Subject: RE: MI-L Hi Ollie, I think you can use the "like" operator in SQL select, with % as a wildcard, so all IDs starting with H would be where ID like "H%" and all IDs containing H would be where ID like "%H%" it only works for strings, though. HTH --------------------------------------------- David Booth Principal GIS Officer Merseyside Information Service www.merseyinfoserv.com > -----Original Message----- > From: Oliver [SMTP:[EMAIL PROTECTED]] > Sent: 17 January 2002 11:39 > To: 'MapInfo-L (E-mail) > Subject: MI-L > > Hi all, > > I have a table with a ID field (char) that has a character followed by 1 > to > 4 numbers. I would like to be able to select all records which have an ID > starting with, say "H". Is there a wildcard type of operator that would > allow me to do something like this? > > Ollie. > > > > > > This Electronic Transmission is intended only for the attention of the > addressee. It may contain privileged and confidential information. If > you > are not the person for whom it is intended, you must not copy, distribute > or > take any action in reliance on it. If you have received this electronic > transmission in error please notify us immediately by telephone, delete > the > transmission and destroy any hard copies. > > Nicholas Pearson Associates has used all reasonable efforts to ensure > that > this message and any attachments are free from viruses. > > Nicholas Pearson Associates > Environmental Planners - Landscape Architects > 30 Brock Street, Bath BA1 2LN > Tel: +44 (0) 1225 445548 > Fax: +44 (0) 1225 312387 > > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > **************************************************************************** **** This email and any file transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the System Manager **************************************************************************** **** This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies. Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses. Nicholas Pearson Associates Environmental Planners - Landscape Architects 30 Brock Street, Bath BA1 2LN Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387 _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
