Invoking UDF in a select statement

[jino]

Hi,

I have an inline User defined function. It goes like this:

CREATE FUNCTION LookUpCodeDesc (@LookupType varchar(50), @LLookupCode varchar(50))
RETURNS TABLE
AS
RETURN (Select LookUpDesc AS Name
from LookUp
Where LookupType = @LookupType
And LookupCode = @LLookupCode)

Can I invoke this function in a SELECT statement? What are the other alternatives to this issue?

Thanks in advance,

Jino

 

[jmeckley]

yes

select dbo.LookUpCodeDesc (value 1, value 2) as [New Column Name]
From ...

value 1 and value 2 can be columns, variables, contants... just as long as the datatype match up.

Jason Meckley
Database Analyst
WITF