Concat sort order

[Anonymous]

Hi guys,

This is puzzling me so I hope you can help.  I am trying to sort on a concat expression

Concat(distinct product_size1, ', ',product_size_alpha)

For some reason this isn't sorting by product_size_alpha though.  Unless I am missing something...?!

When i try the expression above I get this output

Does the sort order within a concat expression not work when alphabetical?

Hoping someone can help because this is driving me mad !

[sasiparupudi1]

Try

Concat(Product_Size1,',',Ord(Product_Size_Alpha))