SELECT siteid, location, linenum, SUM(purchaseprice) AS purchaseprice, SUM(replacecost) AS replacecost

FROM (

-- INSERT your query here .. Remove ORDER BY)

) tbl1

GROUP BY siteid, location, linenum

ORDER BY siteid, location, linenum

We installed iSeries Access on SQL server and that installed the DB2 connectors.  I think they replaced iSeries access with a Java only version, but you should still be able...

SET DATEFIRST 6 ; -- Set first Day of Week to Saturday

SELECT [CreateDateTime],DATEPART(WEEK,[CreateDateTime]) - DATEPART(WEEK,CAST(CAST(YEAR([CreateDateTime]) AS VARCHAR(4))+'-' + CAST(MONTH([CreateDateTime]) AS VARCHAR(2)) + '-01' AS DATETIME))+1 AS WeekNo

FROM yourtable

Replace top line "SELECT t.*" with "DELETE t" and remove ORDER BY clause at the end

1=True, 0=False

Try ... ISDATE(OPS_PROJ_FMIS.STATE_OPTION_2) = 1

Some of these databases don't even have apps using or accessing them. One database I just created a couple of days ago with one table and I manually keyed...

Turned user control off and it worked like a charm. Many Thanks !!