how to change number to charactor (in word) in sql.?

Answer 1

update table set column = cast(column as varchar(1))

(If you're changing the table column type, you would use alter table.) If you don't want to change the table, use a select instead update table.

Answer 2

Using TO_CHAR function, you can convert a number to character !!