in reply to Re^2: (OT) MS-SQL error: 'Invalid operator for data type'
in thread (OT) MS-SQL error: 'Invalid operator for data type'

Assuming I counted parens correctly, then:

(1-1/(9*((SUM(C.Person_count)+1)))+1.96/(3*sqrt((SUM(C.Person_count)+1
+))))^3

[download]

becomes:

POWER((1-1/(9*((SUM(C.Person_count)+1)))+1.96/(3*sqrt((SUM(C.Person_co
+unt)+1)))),3)

[download]

HTH

--
edan

In Section Seekers of Perl Wisdom