Please check below piece of code
CREATE Table #Temp
(ID int Identity(1,1),Title Varchar(20))
CREATE Table #Temp2
(ID int,Title Varchar(20))
INSERT INTO #Temp
SELECT 'Test1'
UNION
SELECT 'Test2'
UNION
SELECT 'Test3'
UNION
SELECT 'Test-1'
UNION
SELECT 'Test-2'
UNION
SELECT 'Test-3'
INSERT INTO #Temp2
Select row_number()Over (order by ID),Title FROM #temp Where Title LIKE '%-%'
UNION
Select row_number()Over (order by ID),Title FROM #temp Where Title Not LIKE '%-%'
SELECT * FROM #Temp2 Order BY ID
Drop TABLE #temp
DROP TABLE #Temp2