+ Reply to Thread
Results 1 to 4 of 4

Wildcards in Select Statement?

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Madison, WI
    MS-Off Ver
    MS Office 2010 (Excel, Word, Access)
    Posts
    72

    Wildcards in Select Statement?

    I'm trying to run a Select statement that, based on the value of a number of different strings, will return the appropriate fund that the string belongs to.

    The problem is that, in one case, I'd like to use a wildcard, since EVERY appropriation that starts with 8 belongs to a particular fund.

    Can I use wildcards in the Case statement, or should I do something like "800" to "899" instead?

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Wildcards in Select Statement?

    Can't you use WHERE Left([Field Name], 1) = 8?

  3. #3
    Registered User
    Join Date
    11-29-2012
    Location
    Madison, WI
    MS-Off Ver
    MS Office 2010 (Excel, Word, Access)
    Posts
    72

    Re: Wildcards in Select Statement?

    Will that work in a Select Case statement? I probably should have been clearer; I'm not using SQL, I'm trying to fill out a form automatically as the program goes down the page.

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Wildcards in Select Statement?

    Oh i thought you meant SQL

    Maybe Try SELECT CASE LEFT(Left(Range(A1), 1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1