I, obviously, don't have SQL Server 6.5 on my machine anymore, but I did
check the index of "Inside Microsoft SQL Server 6.5" before posting, and
there was a reference to the CAST function in it, so I assumed the function
existed in SS6.5.
My error :-( Thanks for the correction.
> > FYI, the CAST function was available in SQL Server 6.5 ... it might also
> > have been available in SQL Server 6.0, but I'm not sure about that.
> When I do
> select cast(getdate() as varchar)
> on a 6.5 server I get:
> Server: Msg 195, Level 15, State 10, Line 1
> 'cast' is not a recognized built-in function name.
> However, when running on SQL2000 server and setting the compatibility
> mode to 65, cast() is accepted.
> Erland Sommarskog, SQL Server MVP
> Books Online (updated!) for SQL 2000 at