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.
