Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    21

    Unanswered: General db question

    what is the difference between 1 & 2

    1. IF con_number is not null AND TRIM(con_number)<> ' '

    2. TRIM(con_number) is not null




    THanks!!

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    is con_number a string, because trim without additional arguments simply removes trailing and leading spaces.

    1) trim(con_number) <> '' will never work. trim(con_number) is not null will.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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