I continue to get an error "Incorrect Syntax near the keyword Execute" on
the command of this Create Function command. I have tried many ways to get
around the error and have had no success. Can anyone enlighten me on the
problem?
My Thanks,
Chris

varchar(50) )
RETURNS
varchar(8000)  AS
BEGIN

'ID = ''' +

END

    You cannot use dynamic SQL from a FUNCTION. This is a known and
documented restriction in SQL2000. Please BOL for more details.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )