Hi,

I has a table of names with this data:

GABRIELA CARVALHO
GRABIEL ALVES

When I try:

select name from table order by name

Thes system return:

GABRIELA CARVALHO
GRABIEL ALVES

But this is wrong, the correct is:

GRABIEL ALVES
GABRIELA CARVALHO

Because GRABRIEL has less letter than GABRIELA.

Why this happen and how fix?

Thanks

Of course you are wrong,

'GABRIELA'<'GRABIEL' because the first word has 'A' on the second position and the second has 'R'. Letter A is much before R.