Ahem.....

Just did some investigating....:blink:

declare @a varchar(10)

set @a = 'abcd a_b'

select charindex('cd', @a) -- matches a pattern - 'cd' is found in @a

select charindex('ce', @a) -- matches a pattern - 'ce' not found in @a

select patindex('%[zce]%', @a) -- treats each of the letters as seperate and tries to find any

--1 of them in @a

select patindex('%[ce]%', @a) -- same outcome as above

Still let me know if there is any other difference between the 2. It may help someone else reading this post.