▲去掉字符串中的所有空格 CREATEFu...... 去掉字符串中的所有空格 CREATE Function f_trimstr(@str varchar(100)) returns varchar(100) AS begin declare @i int declare @s1 varchar(50) declare @result varchar(100) declare @len int select @result = '' select @str = ltrim(rtrim(@str)) select @len = len(@str) select @i = 1 while @i<=@len begin select @s1 = substring(@str,@i,1) if(@s1<>'') begin select @result = @result + @s1 end select @i = @i + 1 end return @result end |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:40 , Processed in 0.218320 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.