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

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

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

On Nov 21, 10:47*am, Patrick A <park...@stradley.comwrote:On Nov 21, 10:47 am, Patrick A <park...@stradley.comwrote: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

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

Steve,

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

Patrick

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

On Fri, 21 Nov 2008 08:21:56 -0800 (PST), Patrick A <parkins@stradley.com>
wrote:
You asked what comes after capital Z, "[" comes after capital Z
However, "{" comes after lower case z.
Sorry, but spelling and capitalization counts.

Chuck