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

Поиск
Список
Период
Сортировка
От Robert Chalmers
Тема How do I return values that begin with non-alphabet characters from a search?
Дата
Msg-id 001901be7bf3$45b7dee0$1a6001cb@chalmers.com.au
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Richi Plana
Дата:
Сообщение: Finding strange patters
Следующее
От: Jens Glaser
Дата:
Сообщение: Nested subqueries in the target list