USP_DATALIST_VIEW1099BOXMINIMUM

      CREATE procedure dbo.USP_DATALIST_VIEW1099BOXMINIMUM

        as
          set nocount on;

          select 
              ID, 
              (BOXNUMBER + ' - ' + VIEWDESCRIPTION) as BOXNAME, 
          case MINIMUMAMOUNT
            --when 0.00  then  'All amounts'

            when 0.00 then 
                case ISDROPDOWNITEM    
                        when 1 then 'All amounts'
                        --else 'N/A'

                        else case BOXNUMBER
                                when '18' then 'All amounts'
                                else 'N/A'
                             end
                end
            --else Convert(varchar, MINIMUMAMOUNT)

            else '$' + CAST(MINIMUMAMOUNT as nvarchar(10))
          end as 'MinimumAmount'
          from dbo.FINANCIALTRANSACTION1099BOXNUMBER
          order by SEQUENCE