34,593
社区成员
发帖
与我相关
我的任务
分享
DECLARE @TB TABLE(NAME VARCHAR(20))
INSERT @TB
SELECT 'Rose Kate' UNION ALL
SELECT 'Rose Cate' UNION ALL
SELECT 'Wid Cate'
DECLARE @FIRSTNAME VARCHAR(500)
SET @FIRSTNAME='ROSE'
DECLARE @LASTNAME VARCHAR(500)
SET @LASTNAME='CATE'
SELECT * FROM @TB WHERE SUBSTRING(NAME,1,CHARINDEX(' ',NAME)-1)=@FIRSTNAME
SELECT * FROM @TB WHERE REPLACE(STUFF(NAME,1,CHARINDEX(' ',NAME),''),' ','')=@LASTNAME
/*
(所影响的行数为 3 行)
NAME
--------------------
Rose Kate
Rose Cate
(所影响的行数为 2 行)
NAME
--------------------
Rose Cate
Wid Cate
(所影响的行数为 2 行)
*/
SELECT * FROM TB WHERE NAME LIKE ''+firstName+' %'
SELECT * FROM TB WHERE NAME LIKE '%'+firstName+'%' AND NAME LIKE '%'+lastName+'%'
?SELECT * FROM TB WHERE NAME LIKE '%firstName%lastName%'
?