Newbie question on replace

From: moido10025 (anonymous_at_discussions.microsoft.com)
Date: 08/31/04


Date: Tue, 31 Aug 2004 14:53:13 -0700

I am trying to replace a text string using like but can't
seem to get it to work. SQL won't accept the first
instance of like. What I have so far:

update note
set contact_1 like '%, %' where contact_1 like '%&%'

Any help would be greatly appreciated.