---将全角符号转换成半角
CREATE FUNCTION ChangeSign ( @fphm VARCHAR(1000) )
RETURNS VARCHAR(1000)
AS
BEGIN
SET @fphm = REPLACE(@fphm, ' ', '') ;
SET @fphm = REPLACE(@fphm, '0', '0') ;
SET @fphm = REPLACE(@fphm, '1', '1') ;
SET @fphm = REPLACE(@fphm, '2', '2') ;
SET @fphm = REPLACE(@fphm, '3', '3') ;
SET @fphm = REPLACE(@fphm, '4', '4') ;
SET @fphm = REPLACE(@fphm, '5', '5') ;
SET @fphm = REPLACE(@fphm, '6', '6') ;
SET @fphm = REPLACE(@fphm, '7', '7') ;
SET @fphm = REPLACE(@fphm, '8', '8') ;
SET @fphm = REPLACE(@fphm, '9', '9') ;
SET @fphm = REPLACE(@fphm, '。', '.') ;
SET @fphm = REPLACE(@fphm, ',', ',') ;
SET @fphm = REPLACE(@fphm, '/', '/') ;
SET @fphm = REPLACE(@fphm, '<', '<') ;
SET @fphm = REPLACE(@fphm, '>', '>') ;
SET @fphm = REPLACE(@fphm, '?', '?') ;
SET @fphm = REPLACE(@fphm, '~', '~') ;
SET @fphm = REPLACE(@fphm, '!', '!') ;
SET @fphm = REPLACE(@fphm, '@', '@') ;
SET @fphm = REPLACE(@fphm, '#', '#') ;
SET @fphm = REPLACE(@fphm, '$', '$') ;
SET @fphm = REPLACE(@fphm, '%', '%') ;
SET @fphm = REPLACE(@fphm, '^', '^') ;
SET @fphm = REPLACE(@fphm, '&', '&') ;
SET @fphm = REPLACE(@fphm, '*', '*') ;
SET @fphm = REPLACE(@fphm, '(', '(') ;
SET @fphm = REPLACE(@fphm, ')', ')') ;
SET @fphm = REPLACE(@fphm, '-', '-') ;
SET @fphm = REPLACE(@fphm, '+', '+') ;
SET @fphm = REPLACE(@fphm, '-', '-') ;
RETURN(@fphm)
END
go