You need to use
CHARINDEX[
^] and
SUBSTRING[
^] function.
My variable
@con1
replace with your column name ;)
DECLARE @con1 NVARCHAR(30)
SET @con1 = '67574989 / 990756576'
SELECT CHARINDEX(' ',@con1,1) AS SlashPosition
SELECT RTRIM(SUBSTRING(@con1, 1, CHARINDEX('/',@con1,1)-1)) AS Contact1,
LTRIM(SUBSTRING(@con1, CHARINDEX('/',@con1,1)+1, LEN(@con1)-CHARINDEX('/',@con1,1))) AS Contact2