Hi Joseph > but What happens > if I only want to select a couple of fields. Then you tell the server which fields you want to select;-) SELECT field1, field2, ... , fieldn FROM table ... > how do you select from a table that is not all lower case what do you mean? what is not all lower case? PostgreSQL returns the contents of the fields as they are. If you need the results to be in lower case use SELECT lower(fieldx), lower(field2),... FROM table respectively SELECT upper(field1), upper(field2), ... FROM table. See chapter 4.4 of the PostgreSQL user's Guide for more. The PHP-Functions to change case are strtoupper() and strtolower(). Hope it helps Regards Conni
