SELECT	'no rows'
WHERE	NULL = 0

SELECT	'no rows'
WHERE	NULL <> 0

quote:

---

Originally posted by Kristen

Note that

where string1=string2

will be case INsensitive if your database is set up to NOT be case-sensitive. (You can force the collation if you want a case SENSITIVE comparison in a non-case-sensitive environment).

You can also do:

where string1 LIKE string2

and "string2" can include the wildcard operators:

% (0 or more characters)
_ and single character
[ABC0123] a single character, one of the set "ABC0123"
[0-9] a single digit
[^0-9] a single character which is not a digit

You can also use an ESCAPE character if you need to escape one of the reserved characters:

WHERE MyColumn LIKE '%\_FOO\_%' ESCAPE '\'

Kristen

---

declare @test table ([option] varchar(2))

insert	@test
select	'A' union all
select	'B' union all
select	'A' union all
select	'C' union all
select	'D' union all
select	'B'

declare	@concat varchar(8000)

select	@concat = isnull(@concat + ',', '') + z.[option]
from	(
		select		distinct top 100 percent [option]
		from		@test
		order by	[option]
	) z

select	@concat as Result

declare @test table ([option] varchar(2))

insert	@test
select	distinct param
from	fnSplit('A,B,A,C,D,B')

declare	@concat varchar(8000)

select	@concat = isnull(@concat + ',', '') + z.[option]
from	(
		select		top 100 percent [option]
		from		@test
		order by	[option]
	) z

select	@concat as Result