i have created a text input on SAS VA report where user can search last name. i have assigned category last name to the input box so as the user types last name it shows the last name starts with that word. client don't want this they want to be able to search last name that contains this specific word and filters the results. (like wildcard search) e.g when searching in “Last_Name” if I search “Hutterian” I only get the records where “hutterian” is the first word in the cell – not records like “Clear Lake Hutterian” or “Three Hills Hutterian” please help!
... View more