如何去掉整列内的中文.
如何去掉整列内的中文.
示例如下:
create table #test(names nvarchar(50))
insert into #test select(N 'asfe2中532 ')
insert into #test select(N '要e2中vb53网站 ')
drop table #test
在线等待...
[解决办法]
select replace(Convert(varchar,names), '? ', ' ') as names from #test
names
--------------------------------------------------------------
asfe2532
e2vb53
(2 row(s) affected)
[解决办法]
if object_id( 'tbTest ') is not null
drop table tbTest
if object_id( 'fnTest ') is not null
drop function fnTest
GO
create table tbTest (names nvarchar(50))
insert into tbTest select N 'asfe2中532 '
insert into tbTest select N '要e2中vb53网站 '
GO
create function fnTest(@name nvarchar(50))
returns nvarchar(50)
as
begin
while PATINDEX( '%[吖-座]% ',@name) > 0
set @name = stuff(@name,PATINDEX( '%[吖-座]% ',@name),1,N ' ')
return @name
end
GO
SELECT dbo.fnTest(names) as name from tbTest
drop table tbTest
drop function fnTest
/*结果
name
-----------
asfe2532
e2vb53
*/
