Re: Compare row ids

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 4 Oct 2005 21:05:43 -0700
Message-ID: <f_GdnRFoRIxezd7eRVn-oQ@comcast.com>

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns96E53FC23219DSunnySD_at_68.6.19.6...
> "Robert Wehofer" <thalion77_at_graffiti.net> wrote in
> news:8caad$43426f3f$d4badae4$19977_at_news.chello.at:
>
> > Hello there!
> >
> > Is it possible to compare row ids with each other?
> >
> > a.rowid > b.rowid
> >
> > is not the real solution due to string comparing.
>
> More importantly, what is the real problem?
>
>
> Two different rows will each have a unique ROWID.
> IMO, comparing ROWIDs is nonsensical.

Except for clustered tables.
Jim Received on Tue Oct 04 2005 - 23:05:43 CDT