LTRIM
From: Geetha <gelangov_at_hotmail.com>
Date: 29 Apr 2003 08:39:24 -0700
Message-ID: <4b40e20a.0304290739.112d174a_at_posting.google.com>
'NN\_DIAGAXIS1\_ID$%'
escape '\'
'NN\_DIAGAXIS1\_ID$%'
escape '\'
Date: 29 Apr 2003 08:39:24 -0700
Message-ID: <4b40e20a.0304290739.112d174a_at_posting.google.com>
I posted this yesterday...somehow, it got removed:
I ran the following sql statement:
SELECT CONSTRAINT_NAME
FROM user_constraints
WHERE trim (constraint_name) LIKE
'NN\_DIAGAXIS1\_ID$%'
escape '\'
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
'NN\_DIAGAXIS1\_ID$%'
escape '\'
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 Tue Apr 29 2003 - 17:39:24 CEST