smallint-->char?

I've changed the datatype on a column from smallint to character and then am trying to "update" the entries to map the "old" integers to letters: 0 --> n (none) 1 --> l (low) 2 --> h (high) and I get error 1213 "A character to numeric conversion process failed" when I run: update table_A set col_1 = "n" where col_1 = "*0*" ...etc for "low" and "high" The "update" substitution seems to happen okay, but the error message interrups the process after each update, so I'm not able to automatically update a bunch of rows! Any help would be greatly appreciated. Thanks, Jim -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Jim Kistler - kistler@an.hp.com # Some see issues and ask, "Why? Hewlett-Packard Co. Imaging Systems # Others see opportunities and 3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?" TEL: 978-659-2251 - FAX: 978-687-7265 # =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-