字母顺序不起作用

Question

I have customer details , have lastname column ,

Some of records contain white space in the name front and back ,

i want to do the alphabetical order , but not working properly,

plz chk this screen shot , i cant able to guess wha tis the exact reason ,

Answer 1

space is considered as character, then it will taken into account when you sort the data.

you might want to trim() data before inserting into database.