Forum Discussion
MikeData
Oct 09, 2023Copper Contributor
Purview partial term search
I have a number of columns in my database schema that use the suffix NUMB, e.g. FANUMB, WRNUMB. I want to do a search in Purview for any column that contains NUMB, but the search does not return all of the values (it only returns one with a number, F0NUMB because the 0 makes the NUMB look like a new word).
I can't figure out a special character to be able to search a partial term, e.g. %NUMB or *NUMB. Does anyone know how I could make this search work?
No RepliesBe the first to reply