Topic: No returned values from criteria Field "like" search...
Hi,
Using SQL I am trying to use a field on the form : thatday ...in order to filter my table list values...
On button Click action SQL.
The following code does NOT send back any error message and no result either...
Thaday field is numeric and the input value is 1
SELECT all id, day, hour FROM VOLUNT where (day like '%{thatday}%')
Any idea why nothing is returned of all existing 10 lines ??
... several with 1 value as their day number
[ SELECT all id, day, hour FROM VOLUNT where (day like '1') ...// Works with no problem ]
Thanks