declare
@value varchar(50)
set @value = '1002902109CC-5350-7344'
select
patindex
('%[^a-zA-Z0-9 ]%', @value) as LocationOfNonAlphaNumeric,
substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value) - 1) ,
substring(replace(@value, substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value)), ''),1,patindex('%[^a-zA-Z0-9 ]%', replace(@value, substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value)), '')) - 1),
replace(replace(@value, substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value)), ''),substring(replace(@value, substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value)), ''),1,patindex('%[^a-zA-Z0-9 ]%', replace(@value, substring(@value, 1, patindex('%[^a-zA-Z0-9 ]%', @value)), '')) ),''),
@value