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]

On Nov 21, 10:47*am, Patrick A <[e-mail]:

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 <[e-mail]:

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]

Steve,

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

Patrick

[Chuck]

On Fri, 21 Nov 2008 08:21:56 -0800 (PST), Patrick A <pa*****@stradley.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