I'm using a CASE statement in a stored procedure. It works ok on one field but multiple case statements give NULL values when run on DTS via Enterprise Manager. However the stored procedure will work when run via Query Analyser.

Any ideas?

Thanks