SUBSTR function in Oracle
Posted on 2000-02-17
Given the following data set from a table xyz with a field name field1 :
and a sequel :
WHERE SUBSTR(field1,4,3)=' '
Normally I would expect to see both the
rows returned. But, It appears like we need to include in the quotes the length of the string that we have used, as in this example ' ' as opposed to ' ', which is what one would use when a SUBSTR is not used.
Is there any reason why SUBSTR behaves like this?
Any information would be appreciated.