Results 1 to 11 of 11

Thread: [2008] Wildcards?

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2007
    Location
    Canada
    Posts
    86

    [2008] Wildcards?

    Well, what I'm looking for are 3 different wild cards I can use while searching a textbox.

    Here's an example of what I need:

    ? Matches any single character at the position. For example, the expression "ABCDE" Like "AB?DE" returns True because it matches any character in the third position of the string as long as the remaining characters match exactly.

    * Matches zero or more characters at the position. For example, the expression "ABCDE" Like "*CDE" returns True because it matches any characters at the beginning of the string followed by "CDE" at the end of the string. Likewise, "ABCDE" Like "AB*" returns True since the two strings begin with "AB" irrespective of any following characters. The expression "ABCDE" Like "*D*" returns True because the string contains "D" preceded and followed by any number of characters.

    ^ Matches zero or more integers at the position. For example, the expression "12345" Like "^345" returns True because it matches any integers at the beginning of the string followed by "345" at the end of the string. Likewise, "12345" Like "12^" returns True since the two strings begin with "12" irrespective of any following integers. The expression "12345" Like "*4*" returns True because the string contains "4" preceded and followed by any number of integers.

    # Matches any single digit (0 - 9) at the position. For example, the expressions "12345" Like "12#45" and "12845" Like "12#45" return True because they match any decimal digit in the third position of the string as long as the remaining characters match exactly.

    Please respond asap
    Thanks,
    Alex
    Last edited by Deathader; Jun 8th, 2008 at 07:06 PM.

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