Hi team,
I hope everyone is doing well.
I have a table as shown below:
My requirement is to order the table on the basis of ID and Relationship in such a way that SELF always shows up first, followed by SPOUSE, but SPOUSE may or may not always be present.
Is there a way to order Relationship by Text, instead of using its length? SON has three characters, so it will show up on first if I order by length, also there is the issue of SPOUSE not showing up in few instances.
Help would be most appreciated, thanks in advance!