Hi ..,
try this batch
DECLARE @String VARCHAR(200) = '长期租金;10/1/2012 ~ 10/31/2012'
SET @String = SUBSTRING(@String,CHARINDEX(';',@String,0)+1,LEN(@String))
SELECT SUBSTRING(@String,0,CHARINDEX('~',@String,0)) [From-Date],
SUBSTRING(@String,CHARINDEX('~',@String,0)+1,LEN(@String)) [To-Date]
Thank you