groovy sql with like clause

sql_with_like_clause.groovy

def query_params = []
def and_where_string = ''
if (params.name) {
   and_where_string = " and where upper(name) like ? "
   query_params << "%" + params.name.toUpperCase() + "%"
}
def query = """
   select * from table
   where table.id is not null
   $and_where_string
"""
def rows
if (and_where_string) {
   rows = sql.rows(query, query_params)
} else {
   rows = sql.rows(query)
}