DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: eliminating two codes using <>

  1. #1
    Join Date
    Feb 2009
    Posts
    5

    eliminating two codes using <>

    In the following procedure one receipt code is being eliminated using <>. How can I change this to eliminate (exclude) two codes?

    select NVL(sum(rc_amt), 0)
    into tot_cont
    from trefrc
    where rc_filer_seq = filer
    and rc_ceipt_code <> 13;

    I want to exclude another code, 19. How can I best accomplish this?

    Thank you, Jim

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking Not in

    +
    Try:
    Code:
    -- Etc...
    and rc_ceipt_code NOT IN (13,19);
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width