/*
-------------去除字符串中间的空格---------
-------------CREATE BY blactte LASTUPDATE 2002-10-10
-------------这是在sqlserver中实现的函数,可以移植到oracle中
*/
CREATE FUNCTION TRIM(@STRING VARCHAR(50))
RETURNS VARCHAR(50)
AS
BEGIN
----------------变量定义-----------
DECLARE @OLDSTRING VARCHAR(50)
DECLARE @NEWSTRING VARCHAR(50)
DECLARE @LENGTH INT
DECLARE @I INT
----------------初始化变量--------------
SET @OLDSTRING=@STRING
SET @LENGTH=LEN(@OLDSTRING)
SET @NEWSTRING=''
--SELECT @LENGTH
SET @I=1
WHILE @I<@LENGTH+1
BEGIN
SET @NEWSTRING=@NEWSTRING+LTRIM(SUBSTRING(@OLDSTRING,@I,1))
SET @I=@I+1
END
---------返回去除空格的字符串---------------------
RETURN(@NEWSTRING)
END