[thelist] MySQl madness

[Ken Schaefer]

Is there some kind of non-printing character prepended to the U? Echo the
ASCII value of each character in that field to eliminate that possibility.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tony Crockford" <tonyc at boldfish.co.uk>
Subject: [thelist] MySQl madness


: Maybe it's my choice of music or maybe it's just old age but how can the
: following list be ordered by cd_title?
:
:    cd_ref cd_title  cd_desc
:    5 Used Unrestored good used condition fully working
:    2 A1 Restored Perfect restored Condition
:    1 A1 Unrestored Perfect unrestored Condition
:    4 Pattern only Very poor condition to be used onlt for patterm ma...
:    3 Urgent action Poor Condition. Preservation required to prevent l...
:
:
: This is the mySQL query:
:
: SELECT * FROM cond_def ORDER BY cd_title
:
: How can U come before A?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~