rgb192
asked on
order by all the words in a sentence
select varcharColumn order by varcharColumn
this is only ordering by first word
how to order by entire sentence
this is only ordering by first word
how to order by entire sentence
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
with really that data? I must doubt that, so you might want to show the "correct" data resp the script to reproduce that behaviour
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
by telling me that this is not possible,
I checked my data and saw that some columns had additional spaces
by telling me that this is not possible,
I checked my data and saw that some columns had additional spaces
ASKER
a c
a a
a b
a d
b
c
want this order
a a
a b
a c
a d
b
c
but I think the sort is only only on the first word before the space