[thelist] SQL question

[Lonnie Kraemer]

> select    { standard list of columns }
>   from reguser
>  where manFirst like '$searchname'
>     or manLast like '$searchname'
>     or womFirst like '$searchname'
>     or womLast like '$searchname'

Could you do:
...
where manFirst+manLast+womFirst+womLast like '$searchname'

?