Parameter Searching 2 Columns

[rbh123456789]

CR 11.5

Hello all,

The below Record Selection statement works perfectly well.
However, i want the {?respsearch} parameter to query the{view.respname} column, AND an addional one named {view.othername}

What would the syntax be?

(
(
{?compsearch} <> "" and
{view.compname} like "*" + {?compsearch} + "*";
)
or
(
{?respsearch} <> "" and
{view.respname} like "*" + {?respsearch} + "*";
)
)

 

[lbass]

(
(
{?compsearch} <> "" and
{view.compname} like "*" + {?compsearch} + "*"
)
or
(
{?respsearch} <> "" and
(
{view.respname} like "*" + {?respsearch} + "*" or
{view.othername} like "*"+ {?respsearch} + "*"
)
)
)

-LB