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
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