SQL delimiter-Based String truncation example

Copy codeThe Code is as follows:
Eclare @ str nvarchar (50 );
Set @ str = '192, 462,464 ';
Select @ str as 'string'
Select len (@ str) as 'character length'
Select charindex (',', @ str, 1) as 'index value of the first comma'
Select LEFT (@ str, charindex (',', @ str, 1)-1) as 'first value'
Select SUBSTRING (@ str, charindex (',', @ str, 1) + 1, len (@ str) as 'extract the following string from the first comma'
Select LEFT (SUBSTRING (@ str, charindex (',', @ str, 1) + 1, len (@ str), CHARINDEX (',', SUBSTRING (@ str, charindex (',', @ str, 1) + 1, len (@ str), 1)-1) as 'intermediate value'
Select SUBSTRING (@ str, charindex (',', @ str, 1) + 1, len (@ str), charindex (',', SUBSTRING (@ str, charindex (',', @ str, 1) + 1, len (@ str), 1) + 1, len (@ str )) as 'last value' -- extract the string from the second comma