How to select a string variable based on a part of the contents of this variable
I've got a string variable that basically contains 4 values ('coach', 'motor fuel', 'motor electrical' & 'other'). I want to select only the lines that contain the word 'motor' with a 'where' statement. I've tried the */~ & match routes, but without succes. Could anyone tell me which statement or character I should use to get all 'motor' lines selected?