drew.allen (10/7/2010)

---

Assuming that your dispLookup table changes relatively infrequently, it might be best to create a trigger on dispLookup to dynamically create/alter a view with the user-friendly column names. ...

tommyh (10/7/2010)

---

Have to agree with that. Design is horrible. However if thats not possible

--Some tables and data to test against.. since i dont have this

create table dispLookup (Code int, Disp...

These tables have been provided for me and I have no ability to change the design I'm afraid.

I can query the system but cannot change the underlying design.

I think the...