How do I return values that begin with non-alphabet characters from a search?

From: "Robert Chalmers" <robert(at)chalmers(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How do I return values that begin with non-alphabet characters from a search?
Date: 1999-04-01 03:53:58
Message-ID: 001901be7bf3$45b7dee0$1a6001cb@chalmers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Browse pgsql-sql by date

  From Date Subject
Next Message Vadim Mikheev 1999-04-09 12:54:59 Re: [SQL] Nested subqueries in the target list
Previous Message Richi Plana 1999-04-01 00:57:54 Finding strange patters