[ms office - 2016] Access Query - find * in string

[MatthewL]

I have a set of data in access and in one of the columns there is some that has *** in the middle of text and numbers either side. The 3's * are characters 9 - 11, if I just search on * it brings all 26k records up, is there a way I can great a query to find these and change for an alternative character to enable finding a bit easier?

[howartp]

https://www.access-programmers.co.uk/forums/threads/wild-card-escape-character.43693/

 

[*] would find the asterisk

*[*]* would find the asterisk within anything else - though this seems a pointless extension of the first option to me.

 

[*][*][*] would then find ***

Edited April 13, 2022 by howartp

[MatthewL]

Thank you, exactly what was needed.

[Ditto]

https://www.access-programmers.co.uk/forums/threads/wild-card-escape-character.43693/

[*] would find the asterisk

*

[*]* would find the asterisk within anything else - though this seems a pointless extension of the first option to me.

[*]

[*]

[*] would then find ***

Purely out of curiosity, but would [***] achieve the same as

[*]

[*]

[*] - if not, why so?

[MatthewL]

Just tried and yes it does.