SELECt ordr_num as num, ordr_date as date, CASE WHEN @status<>'Cancelled' THEN ordr_ship_with ELSE NULL END as shipwith FROM order WHERe ordr_num = @ordrNum

SELECt ordr_num as num, ordr_date as date, CASE WHEN @status<>'Cancelled' THEN ordr_ship_with ELSE NULL END as shipwith FROM order WHERe ordr_num = @ordrNum