You can nest built-in column and scalar functions within other functions in the following ways:
You cannot nest column functions within other column functions.