Wilcard characters for specific positions in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a query which asks only for the 6th-through-9th character in
a 20-character string. Is there a "not this position" wildcard character?
 
You could add a new column to your query that pulls out those digits using
the MID function, then apply your parameter to that...

In a new column, put:

Mid([somefieldname],6,3)
 
I want to create a query which asks only for the 6th-through-9th character in
a 20-character string. Is there a "not this position" wildcard character?
Click to expand...

If I understand correctly, either use Rick's Mid() function
suggestion, or a criterion of

LIKE "?????XYZ*"

to search for XYZ in the 6th-9th characters.

That said - the need to do this suggests that you're violating first
normal form. Fields should be "atomic", containing only one data
value; if bytes 6 to 9 contain a meaningful, separate chunk of
information, you may want to consider splitting this field into three
(or more) component fields. It's much easier to concatenate them for
display than to tease them apart!

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find xth occurrence of a specifiecd character in a string 3
Delete Specific Characters From Text 1
Finding First Alphabetical Character in a String 2
Checking against input mask 2
finding values in a string 1
Find start position of the 9th occurance of a <character> in a str 2
SQL Strings Truncating at 255 Characters ? Why? 1
query part of string 1

Back
Top