Search all tables, all columns for a specific value SQL Server [duplicate]

I have a specific value, let’s say string ‘comments’. I need to find all instances of this in the database as I need to do an update on the format to change it to (*) Comments.

How can I do this? The database is in SQL Server 2000 format.