SQL substring

Hi,
How can I compare two fields if one is a substring of the other?
Something like: ... WHERE StringA like '%' + StringB + '%';

Thanks,
Guy Korland