UFN_SALESMETHOD_COMPATIBLEDELIVERYMETHODS

            create function dbo.UFN_SALESMETHOD_COMPATIBLEDELIVERYMETHODS (
                @SALESMETHODTYPECODE tinyint,
                @NULLSALESMETHODRETURNSALL bit
            )
            returns table
            as
                return 
                    select ID
                    from dbo.DELIVERYMETHOD
                    where 
                        (@NULLSALESMETHODRETURNSALL = 1 and @SALESMETHODTYPECODE is null) or
                        (@SALESMETHODTYPECODE = 2 or DELIVERYMETHOD.PRINTCODE <> 2)