andrew gatt wrote:
P.S. Is it me or is there no way to do case insenstive commands?
Andrew,
If you are asking about case insensitive name comparisons, then there is a way. You must declare the name column in your table to use the NOCASE collation.
create table people (
name text collate nocase,
...
);
HTH
Dennis Cote
