>If you have an IDENTITY column, maybe your could play a game with MOD()
>
>-Mike

That certainly worked. Here it is:

UPDATE tblMyTable
SET Field1 = CASE UID % 3
WHEN 0 THEN RTRIM(Field1) + 'a'
WHEN 1 THEN RTRIM(Field1) + 'b'
WHEN 2 THEN RTRIM(Field1) + 'c'
END
WHERE

Thanks Michael.

Aristotle