字符串处理

[duanzhi1984]

DECLARE  @TEST TABLE (ID VARCHAR(10))

INSERT INTO @TEST(ID)
SELECT 'AAA' UNION ALL
SELECT 'AA' UNION ALL
SELECT 'ABC'

SELECT *FROM @TEST WHERE charindex(ID,'AAA')>0  --返回为AAA,AA 两行。

现在想通过函数charindex只查询出字符AAA的内容,而不返回AA。

意思是必须完全匹配。

[百年树人]

SELECT *FROM @TEST WHERE charindex(','+ID+',',',AAA,')>0 

--or

SELECT *FROM @TEST WHERE ID='AAA'

[duanzhi1984]

[Quote=引用 1 楼 josy 的回复:]
SQL code
SELECT *FROM @TEST WHERE charindex(','+ID+',',',AAA,')>0
[/Quote]
--不错就是有点麻烦！

[xiaoliaoyun]

SELECT *FROM @TEST WHERE charindex('AAA',ID)>0 

[shuangbaojun]

  select * from TB2 where charindex('AA',ID,2)>0

[shuangbaojun]

  select * from TB2 where charindex('AAA',ID,1)>0

[花开花落]

select *from @TEST where ID='AAA'

[永生天地]

完全匹配就直接用 = 吗
[Quote=引用楼主 duanzhi1984 的回复:]
SQL code

DECLARE @TEST TABLE (ID VARCHAR(10))

INSERT INTO @TEST(ID)
SELECT 'AAA' UNION ALL
SELECT 'AA' UNION ALL
SELECT 'ABC'

SELECT *FROM @TEST WHERE charindex(ID,'AAA')>0 --返回为AAA,AA 两……
[/Quote]

[永生天地]

DECLARE @TEST TABLE (ID VARCHAR(10))

INSERT INTO @TEST(ID)
SELECT 'AAA' UNION ALL
SELECT 'AA' UNION ALL
SELECT 'ABC'

SELECT *FROM @TEST WHERE charindex('AAA',ID)>0