Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    7

    Unanswered: check if value is a number

    Hi group,

    we concatenate 2 fields together. eg:
    segment1||'_'||segment2

    Segment1 can have values like: MV200 or MVAR or 100 or whatever.
    Segment2 can have values like: A or AA or AB or 1 or 01 or 99 or it can be empty.

    How can I check that segment2 is a number? Is there a IsNumeric() function or something like in VB?

    Thnx in @vance

    VS

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    yes,

    If(IsNumeric(segment2)) then
    lalala
    else
    lololo
    end if

Posting Permissions

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