select * from table where left$(ID,1) = "H" Arash
-----Original Message----- From: Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 6:39 AM 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. _______________________________________________________________________ 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.
