Hi Guy!

      I think the correct T-sql statement is:

select (len(ivrs)-len(replace(ivrs,'7104','')))/len('7104') from <table name>

where projectid = 2223

and systemid = 6

and calldatetime between

'2006-10-01 00:00:00' and '2006-10-31 23:59:59'

and attresult in (2)

You should...