Hello,
I have a data table that I need to search for exact words. It's an SLX data table called "TEXTBLOB" containing the email with heading, subject and body.
I'm trying to search for names in this "lastname, firstname" format and want to make sure I'm doing it right.
I'm using the Like function cause didn't seem to produce any results and I have to use the wildcard function but want to make sure i'm not returning more results
Example. {HISTORY.LONGNOTES} like ["Jones, Bob"] won't return anything but {HISTORY.LONGNOTES} like ["*Jones, Bob*"] returns results.
Some names appear like Jones Jr., Bob where I need to put the wildcards to find it.
Is this the best way to search for names like that?
Thanks,
Harvey
IP Logged
