# Using wildcards in ActiveRecord Bind parameters

**URL:** <https://www.ruby-forum.com/t/using-wildcards-in-activerecord-bind-parameters/116448>\
**Category:** Rails\
**Created:** [October 5, 2007, 5:02pm UTC](https://www.ruby-forum.com/t/using-wildcards-in-activerecord-bind-parameters/116448 "2007-10-05T17:02:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [October 5, 2007, 5:02pm UTC](https://www.ruby-forum.com/t/using-wildcards-in-activerecord-bind-parameters/116448/1 "2007-10-05T17:02:27Z")

</div>

I am trying to have ActiveRecord do the following:

Select \* from myTable where ( ucase(name) like ‘%findname%’ )

But when I do this in:

@resultList = Entity.find(:all, :conditions =\> [“ucase(name) like ?”,  
“%name%”])

I end up with:

SELECT \* FROM myTable WHERE ( ucase(name) like ‘%‘findname’%’)

ActiveRecord puts single quotes around both of the wildcards, thus  
giving me an SQL Syntax error.

What should I be doing to get this to work?