SQL不会让我替换SELECT语句中的引号(SQL wont let me replace a quote in SELECT statement)

SQL不会让我替换SELECT语句中的引号(SQL wont let me replace a quote in SELECT statement)

我试图从我的SQL导出中的列中删除双引号，并且在研究了正确的方法之后我得到了一个错误...这是我尝试过的方法之一....

SELECT '293453' as custnum, REPLACE(Orders.Order_Comments, '"', '') as FULFILL1, OrderDetails.OrderID as OrderID2, etc.

产生的错误是：

您的SQL无效：参数数据类型文本对替换函数的参数1无效。

I am trying to remove double quotes " from a column in my SQL export and I get an error, after researching the proper way... this is one of the ways I have tried....

SELECT '293453' as custnum, REPLACE(Orders.Order_Comments, '"', '') as FULFILL1, OrderDetails.OrderID as OrderID2, etc.

The resulting error is:

Your SQL is invalid: Argument data type text is invalid for argument 1 of replace function.

最满意答案

看一下这个答案： SQL Server在TEXT字段中查找和替换

text数据类型无法与replace一起replace ，因此您需要将其强制转换为VARCHAR（MAX）

REPLACE(CAST(Orders.Order_Comments AS VARCHAR(MAX)), '"', '')

Take a look at this answer: SQL Server find and replace in TEXT field

The text data type is not valid for use with replace, so you need to cast it as VARCHAR(MAX)

REPLACE(CAST(Orders.Order_Comments AS VARCHAR(MAX)), '"', '')