"Denzil" <denzilpereira@lycos.com> wrote in message
news:298554ad.0310010307.675c430b@posting.google.com...
> Hi...
>
> I need to sort (ORDER BY) the data in a table alphabetically. Now it
> may so happen that the data could contain HTML tags embedded and the
> special first char "<" of the HTML opening tag is used for the ORDER
> BY clause and hence in the following sample of data I have, I always
> have <B>Tiger</B> as the first row.
>
> I need to escape just the HTML tags (<B> in this case and also double
> quotes) for my ORDER BY... What's the best way to achieve this...
>
> Original Table data
> Data in Column1 - Dog
> Data in Column2 - <B>Tiger</B>
> Data in Column3 - Zebra
>
> After doing a ORDER BY
> <B>Tiger</B> --I need this to be the 2nd row ... i.e. ignore <B> for
> the sort
> Dog
> Zebra
>
> Any pointers/ suggestions will be appreciated.
> Thanks for your time.
>
> Cheerz...
> Denzil

"John Bell" <jbellnewsposts@hotmail.com> wrote in message news:<3f7abff7$0$8769$ed9e5944@reading.news.pipex.net>...
> Hi
>
> You may get away with something like:
>
> SELECT Col
> FROM MyTable
> ORDER BY RIGHT(Col, LEN(Col)-PATINDEX('%>%',Col))
>
> or maybe extensive use of the replace function. Another solution would be to
> hold a clean version of the data.
>
>
> John
>
> "Denzil" <denzilpereira@lycos.com> wrote in message
> news:298554ad.0310010307.675c430b@posting.google.com...
> > Hi...
> >
> > I need to sort (ORDER BY) the data in a table alphabetically. Now it
> > may so happen that the data could contain HTML tags embedded and the
> > special first char "<" of the HTML opening tag is used for the ORDER
> > BY clause and hence in the following sample of data I have, I always
> > have <B>Tiger</B> as the first row.
> >
> > I need to escape just the HTML tags (<B> in this case and also double
> > quotes) for my ORDER BY... What's the best way to achieve this...
> >
> > Original Table data
> > Data in Column1 - Dog
> > Data in Column2 - <B>Tiger</B>
> > Data in Column3 - Zebra
> >
> > After doing a ORDER BY
> > <B>Tiger</B> --I need this to be the 2nd row ... i.e. ignore <B> for
> > the sort
> > Dog
> > Zebra
> >
> > Any pointers/ suggestions will be appreciated.
> > Thanks for your time.
> >
> > Cheerz...