I couldn't get that to work, nor could I concatenate anything preceding like. What are the variants such that Like operator would be required?
"[[ACE]]", "[(ACE)]", "[(#ACE)#] ??
Maybe you could use Chr(91) and Chr(93) but not if you need Like operator - or at least not that I've been able to.
EDIT
Like "*[[]dog*" seems to work with [dog] and dog records. Only returns [dog]; so does Like "*[[]dog]*"
Dig deeper at the linked page and you'll see that it says that the ending bracket doesn't require treatment. In fact, it doesn't work if you do thus it's not like it's optional. Whether or not to include it at all might depend on the answer to what the variations are.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.