With containment type partial I also get the error.
Can workaround with:
WHEN $action COLLATE SQL_Latin1_General_CP1_CI_AS = 'DELETE' THEN 'REMOVED'
I found these articles which might be of help :
http://technet.microsoft.com/en-us/magazine/hh534404.aspx
http://msdn.microsoft.com/en-us/library/ff929080.aspx
For better, quicker answers on T-SQL questions, read
Jeff Moden's suggestions.[/url]
"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort