SELECT product_id, SUBSTRING (product_id FROM 0 FOR 3) AS First_Part, SUBSTRING (product_id FROM 5 FOR 2) AS Second_Part, SUBSTRING (product_id FROM 8 FOR 8) AS Last_Part FROM product;
SELECT product_id, SUBSTRING(product_id,1,3) AS 'First_Part', SUBSTRING(product_id,6,2) AS 'Second_Part', SUBSTRING(product_id,9,9) AS 'Last_Part' FROM product
substring('Thomas' from 2 for 3) --returns: hom
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)