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 по дате отправления: