searching for strings of *****

[ghodges]

Hello I have a small problem which i am sure somebody has come accross before.

I have a comments field in a table
somebody has been writing comments preffixed and suffixed with stars

for example "*****hello world*******"

I need to write a query to find thess string of stars "*****"

since i cant just write a query such as Like "*****" as this just returns everything
--------
is * a special character?

I have tried addressing this * as /*, \*, '* ,and many others with no sucess

any ideas would be appreciated....please

 

[boblarson]

Try

Like "*[*]*"

or it might be:

Like "*" & [*] & "*"

 

[boblarson]

Or if that fails you can use this in your criteria:

Instr(1,[FieldNameHere], "*") > 0

 

[ghodges]

thanks again

the correct sollution, as you suggested, is
Like "*
[*]*"


Which i would not have guessed in a million years
Thanks

 

[boblarson]

No problem, glad to help