Re: what comes after z ?
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 06/10/04
- Next message: Brian Henry: "Re: Stored procedure to drop and create table for end user"
- Previous message: Roji. P. Thomas: "Re: Long Select Statement"
- In reply to: colin: "Re: what comes after z ?"
- Next in thread: colin: "Re: what comes after z ?"
- Reply: colin: "Re: what comes after z ?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 10 Jun 2004 10:13:59 -0400
You can try this, even though I'm not an MVP:
select top 256 identity(int, 1, 1) as anint
into #nums
from pubs..authors a, pubs..authors b
select char(anint)
from #nums
order by 1
"colin" <colin@discussions.microsoft.com> wrote in message
news:620B2C9C-8F02-4E57-ABCE-0DE316A1936B@microsoft.com...
> [ doesn't sort after Z, must be the collation, it's not plain ascii, i
wish. can an MVP please answer this, it's important to my app.
>
> thanks!
>
> "Adam Machanic" wrote:
>
> > SELECT CHAR(ASCII('Z') + 1)
> >
> >
> > "colin" <colin@discussions.microsoft.com> wrote in message
> > news:D17E4C7F-B243-4868-96E0-3B361343371C@microsoft.com...
> > > hi,
> > >
> > > i'm storing temp records using þ as the first char to make sure they
are
> > sorted after z (the non temp ones). but i just found out it comes before
th
> > (thorn i suppose). I'm using the collation sql_latin1_general_cp1_ci_as.
so
> > what char is after z-Z? i hope i dont have to change the collation.
> > >
> > > tia
> > >
> > >
> >
> >
> >
- Next message: Brian Henry: "Re: Stored procedure to drop and create table for end user"
- Previous message: Roji. P. Thomas: "Re: Long Select Statement"
- In reply to: colin: "Re: what comes after z ?"
- Next in thread: colin: "Re: what comes after z ?"
- Reply: colin: "Re: what comes after z ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
