Andrew, Try something like: 'Select * from Untitled where Mid$(ID,10,1) = 2 or Mid$(ID,10,1) = 3 into Selection' For Chars
'Select * from Untitled where Mid$(Str$(ID),10,1) = "2" or Mid$(Str$(ID),10,1) = "3" into Selection' For Decimals Enjoy, Jerry Jerry O'Sullivan GIS Consultant ESBI Computing Ltd Stephen Court | 18-21 St. Stephen's Green | Dublin 2 Tel +353 1 7038060 | Fax +353 1 6618455 E-mail: [EMAIL PROTECTED] www.esbic.ie -----Original Message----- From: Andrew Tracey [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 17:54 To: [EMAIL PROTECTED] Subject: MI-L SQL Querying Dear All I am trying to select all records within a column that have the tenth character as either a 2 or a 3. All of the records within the column have 13 numbers. Is there any easy way to produce a query for the above? Regards Andrew Tracey Information Support Officer Corporate Information Corporate Growth and Focus Corporate Development South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] **************************************************************************** ******************** Please do not print this e-mail if you can help it - and help protect the environment. **************************************************************************** ******************** This Message may contain confidential information and is protected by copyright. If you receive it in error please notify us and delete it without making use of or copying it. The addressee and other employees within the Council may read and copy any e-mail reply to this message and other e-mails you send to us. Whilst we use virus checking procedures we accept no liability for viruses and recipients must rely on their own virus checking procedures. **************************************************************************** ******************** The Council's web site address is www.southtyneside.info --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14291 * ** *** ** * ** *** ** * ** *** ** * This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any views or opinions presented are solely those of the author, and do not necessarily represent those of ESB. If you have received this email in error please notify the sender. Although ESB scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. * ** *** ** * ** *** ** * ** *** ** * --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14293