Are you talking about custom SQL? In the coming v8 you can use a parameter in custom SQL. This parameter could be completed in a text field for the parameter.
If you are not talking about that, you can use a quick filter with text entry: http://onlinehelp.tableausoftware.com/v7.0/server/en-us/filter_quick.htm
See the wildcard match section.