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

From Robert Chalmers
Subject How do I return values that begin with non-alphabet characters from a search?
Date
Msg-id 001901be7bf3$45b7dee0$1a6001cb@chalmers.com.au
Whole thread Raw
List 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.



pgsql-sql by date:

Previous
From: Richi Plana
Date:
Subject: Finding strange patters
Next
From: Jens Glaser
Date:
Subject: Nested subqueries in the target list