Actually we have a application where we show the address details like client name,address Line,zip code, state and city concatenated together as one column.
There are cases where client name is empty or address line is empty but when we concatenate the details we don't consider the empty values we just ignore them while concatenation.
So when end-user tries to sort address details ,details should be sorted correctly.But if i sort the client name,address Line etc individually and then apply concatenation my result will not be as expected.
client name || address Line || City || zip code
Ab || Alabama,1-a || Alabama || 1234
Ab || empty || Georgia || 1234
when concatenated details will look like
so if now sort (ASC) the details end-user expects the results to be as follows
but i sort columns individually and then concatenate the results would be
which he thinks to be wrong as Alabama should come before georgia
so i have to concatenate the values and apply sort as i am showing the concatenated values as address details.