Ltrim

I ran the following sql statement:

SELECT CONSTRAINT_NAME

               
                 FROM user_constraints
                 WHERE trim (constraint_name) LIKE

and I got these results
NN_DIAGAXIS1_ID$1
NN_DIAGAXIS1_ID$2 But when I run this:
 SELECT constraint_name, LTRIM (constraint_name,
'NN_DIAGAXIS1_ID$')

                 as trimmed_result                         

                 FROM user_constraints
                 WHERE trim (constraint_name) LIKE

I get the following:

CONSTRAINT_NAME                TRIMMED_RESULT
------------------------------ ------------------------------
NN_DIAGAXIS1_ID$1
NN_DIAGAXIS1_ID$2              2

My question is why do I NOT get anything for the Trimmed_Result for the constraint_name NN_DIAGAXIS1_ID$1?

Thank you very much for your help in advance! Received on Mon Apr 28 2003 - 17:26:47 CEST