Hi Ollie Just "H%"
best regards flavio *********** REPLY SEPARATOR *********** On 17.01.02 at 11:39 Oliver wrote: >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. ******** 10 Years TYDAC Event - Review see www.tydac.ch ********* xxxxxxxxxxxxxxxxxxx ATTENTION: New Address xxxxxxxxxxxxxxxxxxxxx ----------------------------------------------------------------- ############ Mit freundlichen Gruessen / Kind Regards ############ Flavio Hendry- mailto:[EMAIL PROTECTED] ############ TYDAC AG - http://www.tydac.ch #### #### Geographic Information Solutions #### #### Luternauweg 12 -- CH-3006 Bern ############ Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860 ----------------------------------------------------------------- MAPINFO Strategic Partner - PCI Reseller - FME Distributor ESRI ArcGIS Solution Provider ----------------------------------------------------------------- _______________________________________________________________________ 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.