Specific character for query criteria (1 Viewer)

[MaaattC]

Hi there,

I was just wondering how one would filter results with the criteria for a certain character, such as saying a word's 3rd character has to be the letter "h"

For instance, the word "achieve" would be found with this criteria as the third letter is "h"

Thank you for this help.

 

[theDBguy]

Try:

Like "??h*"

 

[Minty]

You can use wildcards in a search term

MyWord Like "??h*"

Would achieve your desired results

 

[MaaattC]

You can use wildcards in a search term

MyWord Like "??h*"

Would achieve your desired results

That did ACHIEVE what I wanted thank you for your help. One last thing, what if I wanted to combine that with say criteria to specify the starting or ending character of that word. I tried to do Like "??h*" & "2*" for example and it went all weird?

 

[Minty]

You have to do it as separate criteria

MyWord Like "??h*" AND MyWord Like "2*"

However, in the example provided as the first criteria is already restricting the output you could do it one hit
Starting with 2
MyWord Like "2?h*"
Ending with 2
MyWord Like "??h*2"