Re: [GENERAL] case insensitive unique index

2001-01-30 Thread Michael Fork
You can create a case insensitive, unique index like this: CREATE UNIQUE INDEX indexname ON tablename (lower(fieldname)) Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Tue, 30 Jan 2001, Culley Harrelson wrote: > is there a way to make a unique index ca

[GENERAL] case insensitive unique index

2001-01-30 Thread Culley Harrelson
is there a way to make a unique index case insesitive for text data? I can change case in my front end code but I thought I'd ask :)