Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Wildcard character in a Pos()??
Thu, Oct 14 2021 9:59 PMPermanent Link

Ian Branch

Avatar

Hi Team,
something like     Pos('*', field) > 0;
Is this possible?
I suspect not.

Regards,
Ian
Fri, Oct 15 2021 2:57 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ian


NO!

Roy Lambert
Fri, Oct 15 2021 5:45 AMPermanent Link

Ian Branch

Avatar

You could have let me down gently... Wink
Fri, Oct 15 2021 10:19 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Ian,

I'm not sure if I understood it right, but is't that the same as :

<ColumnName> LIKE '%<SomeString>'


--
Fernando Dias
[Team Elevate]
Fri, Oct 15 2021 11:09 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Fernando


Well no - but only because POS won't work Smiley

I've been showing Ian how to use POS rather than LIKE to get a faster result but it can only be used for three instances - %string%, string% and %string any other wildcards and its a no go.

Roy Lambert
Image