MSSQLTips

Hi, I'm trying to overcome a situation whereby I have to search through 4-5 columns and produce the results with an order by according to the values matched in these columns. Example: My Table Structure: Create Table TestPfx ( pfx varchar(20), R1 money, R2 money, R3 money, R4 money, R5 money, ) Insert...