Anyone Know What Character Comes After "Z" in an alpha sort?

[Patrick A]

I want to add a character to some fields I want to "push" to the end
of an alpha sort. Anyone know what characters I can use?

Thanks,

Patrick

[steven_nospam at Yahoo! Canada]

Re: Anyone Know What Character Comes After "Z&quot ; in an alpha sort?

On Nov 21, 10:47 am, Patrick A <park...@stradl ey.comwrote:

I want to add a character to some fields I want to "push" to the end
of an alpha sort.  Anyone know what characters I can use?
>
Thanks,
>
Patrick

On Nov 21, 10:47 am, Patrick A <park...@stradl ey.comwrote:

I want to add a character to some fields I want to "push" to the end
of an alpha sort. Anyone know what characters I can use?
>
Thanks,
>
Patrick

I'm guessing that an alpha sort in MS Access would go by ASCII code to
determine what is next. The "Z" is ASC 090 and the "[" is ASC 091, so
I'd say in any sort, the [ would show after the Z.

Keep in mind that the a-z (lowercase) are ASC 097 to ASC 122 so those
might show up AFTER the "[" if you use it.

Steve

[Patrick A]

Re: Anyone Know What Character Comes After &quot;Z&quot ; in an alpha sort?

Steve,

Thanks, but [ shows up first. I figured out how to add another column
without goofing my query.

Patrick

[Chuck]

Re: Anyone Know What Character Comes After &quot;Z&quot ; in an alpha sort?

On Fri, 21 Nov 2008 08:21:56 -0800 (PST), Patrick A <parkins@stradl ey.com>
wrote:

>Steve,
>
>Thanks, but [ shows up first. I figured out how to add another column
>without goofing my query.
>
>Patrick

You asked what comes after capital Z, "[" comes after capital Z
However, "{" comes after lower case z.
Sorry, but spelling and capitalization counts.

Chuck