What is the difference between UPPER and NLS_UPPER when applied to "normal" characters

What is the difference between UPPER and NLS_UPPER when applied to "normal" characters. Have a look at the following lines.

   CREATE TABLE tbl (fld CHAR(30));

   INSERT INTO tbl VALUES ('abc');

   SELECT fld FROM tbl
   WHERE UPPER(fld) = UPPER('abc');

   SELECT fld FROM tbl
   WHERE NLS_UPPER(fld,'NLS_SORT=German') = NLS_UPPER('abc','NLS_SORT=German');

I thought, both selects would bring back the same resultset. However, the second select won't return anything at all.

Michael G. Schneider

mgs_software_at_compuserve.com Received on Thu Oct 09 1997 - 00:00:00 CDT