如何从SQL Server中的varchar值中删除逗号 [英] how to remove comma , from varchar value in sql server

问题描述

如何从sql server 2008中的字符串值中删除commo
例如:-"abcdef，kumar，adf"
仅删除通讯值.


谢谢n advance

how to remove commo from string value in sql server 2008
example :- "abcdef , kumar ,adf"
removing only comm value.


thanks n advance

推荐答案

使用

Use Replace[^] function.

Here is a sample

DECLARE @String VARCHAR(50)
SET @String  = 'abcdef , kumar ,adf'

SELECT @String AS [String before using Replace], REPLACE(@String,',','') AS [String After using Replace]

这篇关于如何从SQL Server中的varchar值中删除逗号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！