What function can help to find * in a table?

[Guest]

I have a table that the users sometimes mistakenly input asterisk * in a text
field. How can I find out the error data?

 

[Ken Snell [MVP]]

You can find the * character by enclosing it in [ ] characters within a text
string:

SELECT * FROM TableName
WHERE [FieldName] Like "*[*]*";

--

Ken Snell
<MS ACCESS MVP>

"What to find * in an access table?" <What to find * in an access
[email protected]> wrote in message
news:[email protected]...

 

[Guest]

Thanks a lot.

You can find the * character by enclosing it in [ ] characters within a text
string:

SELECT * FROM TableName
WHERE [FieldName] Like "*[*]*";

--

Ken Snell
<MS ACCESS MVP>

"What to find * in an access table?" <What to find * in an access
[email protected]> wrote in message

I have a table that the users sometimes mistakenly input asterisk * in a
text
field. How can I find out the error data?