CREATE VIEW [dbo].[Orders_Android]
AS
SELECT        orderno, date_ns, custno,custname,isnull(boneh,'') as boneh,isnull(machinno,'') as machinno,isnull(namekala,'') as namekala,isnull(waznbar,0) as waznbar,isnull(qty,0) as qty,isnull(qty,0) - isnull(qty1,0) as m_qty,safi,
isnull(par,0) + isnull(keraye,0) + isnull(keraye2,0) + isnull(avarez,0) + isnull(Karmozd,0) + isnull(kargari,0) as makharej
FROM            dbo.v_orders