send a column value to a function

Is it possible to send column alias to a function ?

I have a select which is basically have a structure like below ..


select mytable.myfield as

---

,
func_info(field1),
....................
.....................


I get error unknow column at runtime .. .

my question is is this structure wrong ? Whats the correct way to send a column value to a function ?

To pass the value into the function issue:

SELECT func_info(mytable.myfield) as result1

The result of the func_info with the field passed in will be named result1.

Quote:

---

Originally Posted by rcashell

To pass the value into the function issue:

SELECT func_info(mytable.myfield) as result1

The result of the func_info with the field passed in will be named result1.

---

Thanks. This worked.