Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Wildcard character in a Pos()?? |
Thu, Oct 14 2021 9:59 PM | Permanent Link |
Ian Branch | Hi Team,
something like Pos('*', field) > 0; Is this possible? I suspect not. Regards, Ian |
Fri, Oct 15 2021 2:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
NO! Roy Lambert |
Fri, Oct 15 2021 5:45 AM | Permanent Link |
Ian Branch | You could have let me down gently...
|
Fri, Oct 15 2021 10:19 AM | Permanent Link |
Fernando Dias 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Fernando
Well no - but only because POS won't work 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 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |