使用此功能

Use this function

CREATE FUNCTION ExtractInteger(@String VARCHAR(2000))
RETURNS int
AS
BEGIN
DECLARE @Count INT
DECLARE @IntNumbers VARCHAR(1000)
SET @Count = 0
SET @IntNumbers = ''

WHILE @Count <= LEN(@String)
BEGIN
IF SUBSTRING(@String,@Count,1) >= '0'
AND SUBSTRING(@String,@Count,1) <= '9'
BEGIN
SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1)
END
SET @Count = @Count + 1
END

RETURN Cast(@IntNumbers as int)
END
GO

然后在选择查询中调用它.

Then call that in select query.

Select col1,dbo.ExtractInteger(col1) from tbl_temp

简单的答案就像是自己动手做:
http://msdn.microsoft.com/en-us/library/cc295312％28v = expression.40％29.aspx [ ^ ]

Looks like the simple answer is do it yourself:
http://msdn.microsoft.com/en-us/library/cc295312%28v=expression.40%29.aspx[^]