Обсуждение: How do I return values that begin with non-alphabet characters from a search?

Поиск
Список
Период
Сортировка

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

От
"Robert Chalmers"
Дата:
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.