Hi,

I jus wonder why TRIM and SUBSTR are not working on one Oracle9i database
server:

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 10 11:47:01 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

stat@STAT2> select TRIM('Hello ') o from dual;

O
---------------------------
Hello



You see that the string is not trimmed. I would expected (and actually it is
on a different box) the output like this:

O
-----
Hello


Same happen with SUBSTR, doesn't work. But why is this different? Are there
any default sql*plus settings that I'm not aware off?

--
Matthias Wirtz - Norfolk, usa