Your first one is easy. Just use the wizards "keyword" search option which allows you to choose multiple columns and automatically creates the where clause as you have specified.
The second one is more difficult and would require hand code. You can't just pass in LOWER() around columns because there is SQL Injection protection built into the code that won't allow you to call functions from within it.
You could remove that and pass it in... another option is to create a VIEW in your database with Lower() versions of the fields. Then you wouldn't need to specify it in the query, you could also convert the value of the field to lower automatically in the server code so that it wouldn't need to be in the SQL itself.
The final option is to bring in the field AS a column in the query itself and using HAVING instead of WHERE. This can slow things down and requires hand code, so I would suggest the creating a view technique if at all possible.