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?
Bookmarks