การ select ตัดเอาสตริงระหว่างอักขระพิเศษ php/mssql(sqlsrv)

$result = preg_replace('#-(.*?)-#', '$1', $source);

$querycheck = "SELECT * FROM LocalAdmin_TempUpload";
		$resultcheck = sqlsrv_query($conn, $querycheck);
		while($rowcheck = sqlsrv_fetch_array($resultcheck, SQLSRV_FETCH_ASSOC)){
			$getmacname = $rowcheck['machine_name'];
			//echo $getmacname."<br>";
			$queryupdate = "UPDATE LocalAdmin_TempUpload SET family_name = (SELECT t1.family_name FROM LocalAdmin_FamilyName t1 INNER JOIN LocalAdmin_TempUpload t2 
			ON t2.machine_name LIKE '%'+t1.family_name+'%' WHERE t2.machine_name = '".$getmacname."')";

select t1.family_name from [SecurityTools].[dbo].[LocalAdmin_FamilyName] t1 INNER JOIN [SecurityTools].[dbo].[LocalAdmin_DefineGroup] t2
  ON t2.machine_name LIKE '%'+t1.family_name+'%'