Search text in Long

Hi Can you please tell me how to search for a text string in a Long column?

Can I do;
select * from MyTable where MyLongColumn = '%dog%'

Will this retrieve all records having the word dog somewhere in it's Long text column?

Thanks Received on Mon Mar 12 2001 - 10:50:28 CST