On Tue, 2005-03-22 at 08:28 -0500, Griggs, Donald wrote: > For example, a select statement might end with: > ....ORDER BY lastname COLLATE NOCASE; > > I think NOCASE and BINARY are built-in collation sequences, though I'm not > sure where those are listed. >
You can use the NOCASE collation if you want. But be warned that it only works for ASCII text - it does not know how to do a case-insensitive comparison of UTF characters. NOCASE is really intended for testing purposes only. -- D. Richard Hipp <[EMAIL PROTECTED]>
