[font="Courier New"]Hi,

Try Out the following set of SQL Statements. I hope it gives you the desired output. Please pardon, if I am wrong.

SELECT

g.GroupName,

e.ElementName,

SUM(CASE WHEN UserID IS NOT...

Try this alternate coding ...

Its only a way of rewriting existing formats suggested by other learned members from the forum :-

CASE WHEN ISNULL([FieldName], '5K5') = 'V918899'

THEN '5K5'

ELSE ISNULL([FieldName], '5K5')

END...