Well I gave the code at the beginning.

here is my original with 1 inline query:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[MyFunction](

@Usage_Date SmallDAteTime,

@RateCode Varchar(4)

)

RETURNS TABLE AS

RETURN

select,...

Each expression used is for a reason to call a different query under each. "If statements" require declaring a variable and that errors, so was trying to find a work...

Thanks Louis!

Lol, well I guess nothing. I was assuming the returns could only be in the top header of what i was selecting from after the begins. thanks!

Just FYI, this is the function I tried.

Create FUNCTION RateClassTotals ( @Year VARCHAR(8),@Code VARCHAR(30) )

RETURNS @RateClassTable TABLE

(

Rate_Cat_Cd varchar(10),

Year...