No, SQL Server 7 has only one collation for the whole server which is chosen
at installation and which you can't change unless you reinstall the server
or rebuild the master database.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"Nice Chap" <NiceChapPlasmaDyne.com> wrote in message
news:uFKAl35RDHA.1552TK2MSFTNGP10.phx.gbl...
> Does this clause exist in Sql Server 7.0 ?
>
>