Forum Discussion

MikeData's avatar
MikeData
Copper Contributor
Oct 09, 2023

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