Original Post
I am having some SQL syntax woes that I cant seem to solve. I need to write a User defined function that conditional returns one table or another. so basically, CREATE FUNCTION dbo.AgentorSrvProvider() RETURNS TABLE AS DECLARE @Agent varchar(40) DECLARE @SrvProvider varchar(40) IF(dbo.tblAgent.Login = SYSTEM_USER) @Agent = 'Agent' RETURN( @Agent, SELECT Login FROM dbo.tblAgent WHERE (Login = SYSTEM_USER)) ELSE @SrvProvider = 'Service Provider' RETURN( @ServiceProvider, SELECT SrvProviderNm FROM dbo.tblSrvProvider I have not been using SQL long at all and Ive looked around, but cant seem to find proper syntax to do something like this. Thank you, /*@SrvProvider = 'Service Provider'*/