I am looking for the best way to approach this task
I have a sample name which is written by the user and not necessarily put in the same order every time. there are a few key strings to look for. What I want is a query or module that will update a field in the table based on whether or not it finds a str in the sample name.
these keywords would be things like "mdl" "std" and others. what I have com up with is using the instr function to find the keyword string and then update the field based on that. I cant figure out the syntax for instr though to save my life.
there must be an easier way because this would create multiple redunant queries and be too time consuming
hope someone can shed some light on this for me