selecting on a parameter (Like) 1

[BlurredVision]

I have the following select statment, which fails if the user doesn't enter more then one value for the parameter. Does anyone know of a cleaner way of doing this?

Using BOXI against sql


if {?Location}[1] <> "" and
{Name} like '*'&{?Location}[1]&'*' then true else
if {?Location}[2] <> "" and
{Name} like '*'&{?Location}[2]&'*' then true else
false

Many thanks

 

[lbass]

You could use:

(
(
ubound({?Location}) >= 1 and
{Name} like "*"& {?Location}[1]& "*"
) or
(
ubound({?Location}) >= 2 and
{Name} like "*"& {?Location}[2]& "*"
) or
(
ubound({?Location}) >= 3 and
{Name} like "*"& {?Location}[3]& "*"
) //etc.
)

-LB

 

[BlurredVision]

Duh.. always forget about ubound..

That did it.. many thanks.