Find the column index by its name in SQL : If I have three columns, 'syscode', 'loc_cod', 'loc_name' but wanted to know that 'loc_name' was 3rd in order, how could I retrieve that with a SQL query?

Using T SQL/SSMS.