Received: from nanguo.chalmers.com.au (gateway.chalmers.com.au [203.1.96.1]) by hub.org (8.9.2/8.9.1) with ESMTP id WAA70585 for ; Wed, 31 Mar 1999 22:49:07 -0500 (EST) (envelope-from robert@chalmers.com.au) Received: from carbon (carbon.chalmers.com.au [203.1.96.26]) by nanguo.chalmers.com.au (8.9.1/8.9.1) with SMTP id NAA20280 for ; Thu, 1 Apr 1999 13:47:35 +1000 (EST) Message-ID: <001901be7bf3$45b7dee0$1a6001cb@chalmers.com.au> From: "Robert Chalmers" To: Subject: How do I return values that begin with non-alphabet characters from a search? Date: Thu, 1 Apr 1999 13:53:58 +1000 Organization: R.A.Chalmers Pty Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Hi, How do I find names in a table that begin with non-alpha characters? Like. "2B-Rich. Pty Ltd" or "#1 Business". I can get those that start with "A" for example ( 'A%' ), but how do I cover the range of non alphas? Thanks Robert --- http://www.chalmers.com.au. Publications From China in 24 different languages. English, French, German, Russian, Arabic, Spanish, Chinese, Burmese, Bengali, Hindi, Indonesian, Italian, Japanese, Korean, Portuguese, Persian, Swahili, Sinhalese, Thai, Tamil, Urdu, Vietnamese. China Books for CIBTC, Beijing.