Advanced SQL queries with '#WC#<Search Term>#WC#'

[Giu Platania]

all,
my understanding is that  '#WC#<Search Term>#WC#' returns a String of the search term. However this is not working as expected
given a search value of '9.9.8'

Code: [Select]

....
AND ApplicationIdentifier.value LIKE '#WC#<Search Term>#WC#'

returns as expected:

• '9.9.8'
• '9.9.8'.1
• '2.9.9.8'

that is correct but not precise if the user wants the exact match. However

Code: [Select]

....
AND ApplicationIdentifier.value = '#WC#<Search Term>#WC#'

returns nothing !?
what Am i missing here?

[Geert Bellekens]

<Search Term> will be replaced by the value you enter in the search box.
#WC# will be replaced by the appropriate wildcard (% or * depending on the database driver)

So if you want to search for an exact match, use <Search Term> without the wildcards.

Geert

[Giu Platania]

it works!
great as always Geert!!!
thank you

[Paolo F Cantoni]

Eh, Giuseppe,
LOVE the tagline!

"The above content reflects my own opinion and is not endorsed by Monthy Python"
(my emphasis)

Paolo

[Giu Platania]

grazie Paolo!
😅