Hi,
I have a Table "SALES" with a Field "Name".
Name can have the following 4 values:
1 "Name 1"
2 "Name 2"
3 "Name 3"
4 ""
I have to pass the Name value in a function "EVALUATION" that execute a Query in "SALES".
The query has to filter on "Name" values and if Name is "" has to ignore the filter on "Name" and take all Name Values ("Name 1", "Name 2", "Name 3").
I can see form other post in the Forum that wildcards are not allowed.
Is there any trick in order to pass a "*" value in "EVALUATION" and skip the filter on "Name"?
tks
pippo