Sql left characters

This article is tagged with: Sql left characters and mysql

sql left characters

-- For Oracle only
-- syntax
SUBSTR(<main-string>,1,<number-of-characters>)
-- example
SUBSTR('Useless stuff',1,10) -- OUTPUT: Useless st
-- practical example
SELECT SUBSTR('Useless stuff',1,10)
FROM DUAL;</number-of-characters></main-string>

This article is tagged with: Sql left characters and mysql