cat infile | translate all occurences of "NOT NULL" to ""

what command do I use to substitute all occurences of a certain string (say,
"NOT NULL") with another arbitrary string, (e.g. "")?  I've tried grep and
tr, but can't figure it out.

Thanks,

Dan Browning
Network & Database Administrator
Cyclone Computer Systems