Results 1 to 6 of 6

Thread: Like

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Like

    I have this statement :
    if Romisch Like "BAT [2-9]*" then
       Do some Orders
    endif

    Should BAT3 be true ?
    Should BAT4 be true ?

    I need All BAT2, BAT3, BAT4, ...., BAT9 to be true.

  2. #2
    Join Date
    Nov 2003
    Posts
    5
    If I understand correctly u could try something like this,

    if Romisch Like "BAT#" then
    Do some Orders
    endif


    The # implies a numeric character


    HTH

    M.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by Michelangelo
    If I understand correctly u could try something like this,

    if Romisch Like "BAT#" then
    Do some Orders
    endif


    The # implies a numeric character


    HTH

    M.
    Thank you for your reply, you are right, but I need the BAT2, BAT3, ..., BAT9, BAT10, BAT10a, BAT11,....


    so I solved it like so
    if Romisch Like "BAT[2-9]*" Or Romisch Like "BAT10*" Then

    END IF
    What do you mean?

  4. #4
    Join Date
    Nov 2003
    Posts
    5
    I think your statement should just be

    If Romish Like "BAT*"

    It returns everything starting with BAT


    The # wildcard implies a numeric value. Look in the help for all possible wildcards.

    M.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by Michelangelo
    I think your statement should just be

    If Romish Like "BAT*"

    It returns everything starting with BAT


    The # wildcard implies a numeric value. Look in the help for all possible wildcards.

    M.
    Yes, but I don't need BAT1
    only from BAT2 ---- BAT12

    Thanks

  6. #6
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Cool do it like this(without *)

    SELECT Table2.tbl2
    FROM Table2
    WHERE (((Table2.tbl2) Like "hal[2-8]"))

Posting Permissions

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