Hi,
I am using LTRIM function with = operator. For some LTRIM its giving correct resultIt's giving me some different results like below.
select LTRIM('GRAIN=HASH','GRAIN=') AS RES from dual;
RES
----
HASH
but for below I am getting some different results.
select LTRIM('GRAIN=NONE','GRAIN=') as RES from dual;
RES
---
ONE
select LTRIM('GRAIN=NANE','GRAIN=') as RES from dual;
R
-
E
select LTRIM('GRAIN=RAHUL','GRAIN=') as RES from dual;
RES
---
HUL
Please let me know why LTRIM behaves like this.Thanks