IN Clause Question - Function

Greetings.

I have written a function that returns a CHAR similar to:

('02-00','01-00','12-99')

The function name is get_Past3Months.

The query that uses the function is as follows:

SELECT	customer_code,
	premis_code,
	action_date
FROM	(
	SELECT		get_Past3Months in_DateString
	FROM		DUAL
	) months,
	history
WHERE	TO_CHAR(action_date, 'MM-YY') IN months.in_DateString

Will my scheme work?

TIA Received on Tue Mar 14 2000 - 08:24:31 CST