Hi all...
Here is the equivalent of SUBSTR of Oracle in SQL Server will be ..
Here is the equivalent of SUBSTR of Oracle in SQL Server will be ..
ORACLE
|
SQL SERVER
|
Select
SUBSTR('TEST_A,TEST_B,TEST_C',1,4)
from dual;
|
Select
SUBSTRING('TEST_A,TEST_B,TEST_C',1,4)
|
Select
SUBSTR('TEST_A,TEST_B,TEST_C',1)
from dual;
|
Select
SUBSTRING('TEST_A,TEST_B,TEST_C',1
,LEN('TEST_A,TEST_B,TEST_C'))
|
No comments:
Post a Comment