SQL truncate string code example
Example 1: sql value of string
-- Specifically for Oracle
-- EXAMPLE
CAST('732.98' AS INT)
/* SYNTAX
CAST(<value_to_cast> AS <data_type_to_cast_to>)
*/
Example 2: grab part of a string sql
SELECT
SUBSTRING('SQLTutorial.org',
POSITION('.' IN 'SQLTutorial.org'));
Example 3: grab part of a string sql
SELECT SUBSTRING('SQLTutorial.org');