Olivia,
The option "Contains" looks like this in SQL "YourField like %[value]%"
The Option "Ends With" looks like this "YourField like %[value]"
The Option "Starts With" looks like this "YourField like [value]%"
So one of these should work for you as all three use wildcards.