need help with query

I want to sum the records in a table (u) which have 'P.M.' in a field value
and test against a fixed limit

something to the effect of :

case
when SUM(substring(u.sTime,1,4)='P.M.') <= 64 Then ....

except it should work

any suggestions would be appreciated

TIA

Try something like

SELECT Type
FROM Titles
GROUP By type
HAVING SUM(CASE WHEN type='business' Then price Else 0 End) < 50

--
Roji. P. Thomas
Net Asset Management
<a rel="nofollow" style='text-decoration: none;' href="https://www.netassetmanagement.com" target="_blank">https://www.netassetmanagement.com</a>


"TJS" wrote in message

 >I want to sum the records in a table (u) which have 'P.M.' in a field value
 >and test against a fixed limit
 >
 > something to the effect of :
 >
 > case
 > when SUM(substring(u.sTime,1,4)='P.M.') <= 64 Then ....
 >
 > except it should work
 >
 > any suggestions would be appreciated
 >
 > TIA
 >