IF OBJECT_ID('DBO.GET_NoChinese') IS NOT NULLDROP FUNCTION DBO.GET_NoChineseGOCREATE FUNCTION DBO.GET_NoChinese(@S VARCHAR(100))RETURNS VARCHAR(100)ASBEGINWHILE PATINDEX('%[^0-9a-zA-Z]%',@S) > 0BEGINset @s=stuff(@s,patindex('%[^0-9a-zA-Z]%',@s),1,'')ENDRETURN @SENDGO--测试 ...