+13How All.
How could I set up a parameter in Aurena Lobby to understand “Like” where condition with % so I will be able to type a part of the text.
In the example bellow, if I use like condition with %, the element in Aurena doesn’t not work, just in IEE. IF I remove the %, it works fine.
Is it possible?
Tks a lot!
this way works without %.
In Aurena Lobby does not with %
UPPER(ITEM_DESCRIPTION) LIKE NVL(UPPER('%$CPF_NOME$%'),'%')
Best answer by Tomas Ruderfelt
If there is a problem with % in your version maybe try this:
UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))
CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:
SELECT ASCII('%')
FROM dual
If there is a problem with % in your version maybe try this:
UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))
CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:
SELECT ASCII('%')
FROM dual
+13If there is a problem with % in your version maybe try this:
UPPER(ITEM_DESCRIPTION) LIKE UPPER(CHR(37) || '$CPF_NOME$' || CHR(37))
CHR function gives you character “%” if you use number 37. You can find the ascii number of a character by doing:
SELECT ASCII('%')
FROM dual
Hi
Tks a lot for attention and help!
Br.
Lopes
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
