|
||||||
|
InStr Function By Richard Rost 2 years ago Find a String Within a String in Microsoft Access In this Microsoft Access tutorial, I'm going to show you how to determine whether or not a specific substring appears inside of another string using the InStr function in a query. It also works in VBA. Freddy from Arlington, Texas (a Gold Member) asks: My vendor uses a status code that has the characters "DSC" in it if the part has been discontinued. Problem is, that status code also includes a bunch of other random information we don't care about. How can I indicate which parts have that code. I know how to do a search manually, and I know how to do a wildcard search in a query, but that shows ONLY those records. I still want to see all of the rest of them. Pre-Requisites
Links
Recommended Courses
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, InStr Function, string within a string, find a character in a string, search for a word, find a substring
|
||||||||||||||||
| |||
Keywords: FastTips Access InStr Function, string within a string, find a character in a string, search for a word, find a substring PermaLink InStr Function in Microsoft Access |