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