Select * From tablename Where Left$(ID, 1) = "H" Into Selection Just replace "H" with your letter, this will only work if the first character is the letter after the equals. You could also use Mid$(ID, 1, 1) to return the first letter of the ID string.
-----Original Message----- From: Oliver [mailto:[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/attachment(s) has been virus checked upon receipt at the OS and is free of all known viruses. *************************************************************** *************************************************************** For more information on Ordnance Survey products and services, visit our web site at http://www.ordnancesurvey.co.uk *************************************************************** _______________________________________________________________________ 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.