Tips and Tricks

Well, when I create a table in Access and do a sort ascending, I get spaces, symbols, numbers, letters.

The list below uses the US English character set:

! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _`a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~  ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ' ' " " o - - ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

I forgot to mention, the space comes first. These numbers can be viewed by using Excel's CHAR( ) function on numbers 32-255.

I found a really nice table at pcguide.com that includes the entire character set with dec, bin and hex conversions. And yes, after the control characters (NUL, SOH, etc..) the space if first.

This question was closed by the author