As the pervious poster asked, what is the purpose? Remember, there are always multiple ways to accomplish a task in SQL. It is the end result/goal that dictates the best solution.

For example, do you need a function that will generate a unique number, or are you creating a table that needs a unique id column?