开发者

Help with SQL query?

开发者 https://www.devze.com 2023-02-19 18:00 出处:网络
I have a table which has among others a column called cust_name of type开发者_运维技巧 varchar(30). I want to retrieve a list of all the name which does not contain the letter \'P\' in it. what is the

I have a table which has among others a column called cust_name of type开发者_运维技巧 varchar(30). I want to retrieve a list of all the name which does not contain the letter 'P' in it. what is the query I should use?


SELECT C.cust_name
FROM Customer C
WHERE C.cust_name NOT LIKE '%P%'
0

精彩评论

暂无评论...
验证码 换一张
取 消