Use the LIKE keyword. Not sure of the wildcard. Probably %

BOL should help...

EDIT: They did. It was %