infomania
Programmer
- Oct 27, 2002
- 148
- 0
- 0
I want to create a formula where all records are selected in the event a numeric parameter (or any parameters) is not given.
I can do this for a string fields as below:
If {?Item Number}="" then {Command.itemNumber} like "*" else
{Command.itemNumber} like "*"+{?Item Number}+"*"
However, I am stumpted as to how to do this with a numeric field where the parameter does not allow for a null.
I can do this for a string fields as below:
If {?Item Number}="" then {Command.itemNumber} like "*" else
{Command.itemNumber} like "*"+{?Item Number}+"*"
However, I am stumpted as to how to do this with a numeric field where the parameter does not allow for a null.