Run into a strange question, if a Column has two records
The Column of
BK - TEXT
BKPB

In SQL ASC is shown as:
BK - TEXT
BKPB

But in the DataWindow ASC is shown as:
BKPB
BK - TEXT

See ASCII - 45, P is 80, so you should collation of SQL is correct, this don't know if PB bugs, which have a solution?

CodePudding user response:

Really do not have a serial number line,

CodePudding user response:

refer to the original poster sywen response:

run into a strange question, if a Column has two records
The Column of
BK - TEXT
BKPB

In SQL ASC is shown as:
BK - TEXT
BKPB

But in the DataWindow ASC is shown as:
BKPB
BK - TEXT

See ASCII - 45, P is 80, so you should collation of SQL is correct, this don't know if PB bugs, which have a solution?

This is a problem of ordering rules, each language may not be the same, if some Null at the top, some row behind, there is nothing to tangle, if you want to - ahead of P, then use SQL sort