This
SELECT 1 WHERE '95b5a221aeba15c' IN (E'\'' ||
replace('95b5a221aeba15c+fb4e7219ab898ce+b08586cb81059f9','+',''',''') ||
E'\'') returns no row while
SELECT 1 WHERE '95b5a221aeba15c' IN
('95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9') returns a row.
What is the difference between E'\'' ||
replace('95b5a221aeba15c+fb4e7219ab898ce+b08586cb81059f9','+',''',''') || E'\''
and '95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9'?
Cheers,
Chris
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
