DECLARE @Karakter VARCHAR(25) = '1010-6.2' ; SELECT SUBSTRING (@Karakter, 0, CHARINDEX ('-', @Karakter, 0)) Oncesi , SUBSTRING (@Karakter, CHARINDEX ('-', @Karakter) + 1, LEN (@Karakter)) Sonrasi ;