At 8/14/2001 01:59 PM (Tuesday), Joe Martinez wrote:

>I'm trying to find an SQL statement that will prepend a string to a
>field for a certain set.

If the column is a CHAR or VARCHAR try the concatenation operator, ||,
instead of +.

update mytable set mycolumn = ('100' || mycolumn) where...