Send a column value to a function

[windowsxp]

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 [HR][/HR],
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 ?

[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.

[windowsxp]

@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.