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>