Real SQL like problem ( 2 Views )

1. Hi, I want to search the database by the first letter of company names. I can use the LIKE in my SQL query (LIKE 'A%' ) to get the result.
   
   But my question is how I can search those companies whose name started with numbers? I tried " (cmp_name_en LIKE '0%' OR LIKE '1%' OR LIKE '2%' OR LIKE '3%' OR LIKE '4%' OR LIKE '5%' OR LIKE '6%' OR LIKE '7%' OR LIKE '8%' OR LIKE '9%' )", but database reports errors. My database is Postgresql 7.4.1
   
   Desperately need your help, thank you!
   Ji Tao
   
   
   (Ýnanç Ataer , Saint Kitts and Nevis)


2. Code:

   ---

   where substring(cmp_name from 1 for 1)
between '0' and '9'

   ---

   You may have to change the substring syntax. As written is ANSI SQL but I donät know if that is supported by Postgres.
   
   
   (mehmet sipan, Bahrain)


3. Thank you, I know what my problem is it is really stupid.
   It should be:
   cmp_name_en LIKE '0%' OR cmp_name_en LIKE '1%' OR cmp_name_en LIKE '2%' OR cmp_name_en LIKE '3%' OR cmp_name_en LIKE '4%' OR cmp_name_en LIKE '5%' OR cmp_name_en LIKE '6%' OR cmp_name_en LIKE '7%' OR cmp_name_en LIKE '8%' OR cmp_name_en LIKE '9%'
   
   The substring solution also works great in postgresql Thank you very much.
   
   
   (ferit, Netherlands Antilles)

Related Topics ... (or search in 1.720.883 topics !)