我想在自定义列中使用like运算符。表包含"姓名"one_answers"姓氏"列。
我可以用这样的东西吗?
Select (Name+' '+ Surname) as NS from Customers Where NS like '%mat%'
提前谢谢。
您不能使用任何类似的运算符,您需要重复表达式:
SELECT (Name+' '+ Surname) as NS
FROM Customers
WHERE (Name+' '+ Surname) LIKE '%mat%';
或者将表达式放入子查询中,然后引用列:
SELECT NS
FROM (SELECT (Name+' '+ Surname) AS NS FROM Customers) AS c
WHERE NS LIKE '%mat%'