 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2008how do I search for an * in a text field?
how do I search for an * in a text field? I mean the character * (ASCII42) rather than a wild card. I've tried 'like chr(42)' in the query parameter but this returns reocrds that don't have a * in the text field To find an asterisk anywhere in the field you would use Like "*[*]*" To find a field that is exactly on asterisk = "*" or use Like "[*]" The use of the square brackets tells the SQL engine to look for exactly what is in the brackets or it lets you specify a range of characters. Check out the wild card help - in the help dialog type "wild card" John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County > how do I search for an * in a text field? I mean the character * (ASCII42) > rather than a wild card. I've tried 'like chr(42)' in the query parameter but > this returns reocrds that don't have a * in the text field |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.