Hi:
I use Redhat OS, postgresql database and PHP build my website, I import datas to postgresql, and all the table field name is uppercase like the follwing:

Attribute |    Type     | Modifier
-----------+-------------+----------
 WHFILE    | varchar(10) |
 WHFLDI    | varchar(10) |
 WHFLDE    | varchar(10) |
 WHIBO     | integer     |
 WHFLDB    | integer     |
 WHFLDD    | smallint    |
 WHFLDP    | smallint    |
 WHFTXT    | varchar(50) |
 WHFLDT    | varchar(1)  |
psql query like following can do:
movextest=# select "WHFILE", "WHFLDI","WHFTXT" from cfiffd00 where "WHFILE" like upper('%mpccid%');
but in PHP the query can not run! why? and how to run like this condition?