SUBSTRING FUNCTION
Return a portion of a selected string.
SQL Server
Syntax - SUBSTRING(string, starting position, ending position)
SELECT SUBSTRING('WORD',1,2)
Returns 'WO'
Oracle
Syntax - SUBSTRING(string, starting position, ending position)
SELECT SUBSTR('WORD',1,2)
Returns 'WO'This free website was made using Yola.
No HTML skills required. Build your website in minutes.
Go to www.yola.com and sign up today!
Make a free website with Yola