Hi folks,


Assume that I have one table named Table1, and contains these values, as the following:

Table1
-------
1
2
3
4
5

I want select from this table as the output should replace the numbers with number names (just to consider how replace works), in other word, the out out should be as this:

one
two
three
four
five

I want to know what is the right syntax for dealing with REPLACE function. Looking forward for your help in this.