Create Function dosn't work in SQL7 1

[Mdavis123]

SQL 2000 works fine, SLQ7 doesn't recognize this format.
Any body recognize the problem for SQL7???

Create function mmddccyy(@indate datetime)
Returns Varchar(8)
AS
Begin
--strip out the seperator
...
End

Thanks MikeD

 

[osjohnm]

Hi Mike

User-Defined functions are only supported in SQL Server 2000. It is one of the new features in 2000, so unfortunately you won't get it to work in 7.

Hope this helps

John