Re: Materialised Path Heirarchy
From: stu <smcgouga_at_nospam.co.uk>
Date: Thu, 27 Mar 2003 11:32:41 -0000
Message-ID: <b5unk5$10o$1$8302bc10_at_news.demon.co.uk>
Date: Thu, 27 Mar 2003 11:32:41 -0000
Message-ID: <b5unk5$10o$1$8302bc10_at_news.demon.co.uk>
"Murat Okay" <murat_okay at yahoo dot com> wrote in message
news:#42WTMF9CHA.2316_at_TK2MSFTNGP10.phx.gbl...
> Stu,
> As far as I know, SQL Server doesn't support this. You must do it
> "manually".
I take it you mean SQL does not provide numeric sorting on a text field. This is what i thought and why I came up with the idea to have a fixed length representation for each level.
Cheers
Stu
Received on Thu Mar 27 2003 - 12:32:41 CET