>Hi,
>
>I get error "Incorrect syntax near ')'." If I remove the following line from the SQL Select, the error goes away:
>
>

>"sum( CASE WHEN MYTABLE.REC_ID = '0' THEN MYTABLE.MYFLD ELSE 0.00 ) as ST_HOURS, " 
>

>
>What could be wrong with the above line syntax?

You forgot "end"


sum( CASE WHEN MYTABLE.REC_ID = '0' THEN MYTABLE.MYFLD ELSE 0.00 END ) as ST_HOURS,

Cetin