A simple - "Marked" as status , worked. Thanks so much.

I get it. All rows shows marked but column name shows "constant", how do I change "constant" to "status"?

SELECT 'Packed', so.num AS ordernum, so.customercontact,

so.dateissued, so.datecreated, so.datecompleted

FROM ship

LEFT JOIN so...

It doesnt work that way. I get wrong info if I sum up the time.

The total quantity(sum(woitem.qtytarget) as total) result set is showing more than 6 numbers after the decimal point (example:442.2565485). How can I limit it to 2. (example:442.25)

select wo.num,...

SELECT * FROM #SampleData

ORDER BY CAST( REPLACE( num, ':', '.') as decimal(12, 3))

This worked perfect. Thanks SO much.

The problem here is, I am not using any tool. I am working on inventory tool, which through JDBC connects to database server. Database is called fishbowl database. Once I...

Its Varchar. Dont know how to change it

yeah thats something from the subquery list. I can use T-sql. Can you help me with that. Also in concatenation?

Thanks. Btw, sum() didnt work.

I am using data tab in fishbowl inventory. Firebird sql. Database is connected to this software. Btw, labor isnt being used. I have removed it. Can you edit below code...