SELECT LIKE question

[Charlatat]

search string = 'PHDOL1106ABCWk10'I can presently do a select statement WHERE (field LIKE '%PHDOL1106%') which works fine, but there's a lot of results to process.I would like it to return fewer results, so is there a way of doing a search similiar to this: WHERE (field LIKE '%PHDOL1106???Wk10%') ? The ABC in the above search string varies and so would need the query to process any letter in the ? part. Is this doable? If this doesn't make sense, let me know and I'll try to explain it better. Thanks

[pulpfiction]

You can try _ "underscore" wildcard. this looks for only one character..... .......... WHERE (field LIKE '%PHDOL1106___Wk10%') [contains 3 underscore, one for each character]

[Charlatat]

You can try _ "underscore" wildcard. this looks for only one character..... .......... WHERE (field LIKE '%PHDOL1106___Wk10%') [contains 3 underscore, one for each character]

Thanks, that was EXACTLY what I needed!