hi there.. I have 3 columns/fields in my master table(T_MASTER), class size and type... examples would be LAC_BP_13010 where LAC is the class, BP is the type and 13010 is the size. There are roughly 7 different classes, 4 types and many sizes..
What i want to be able to do is combine the values from each of the 3 columns and have that combined value in its own column... Im sure its a very easy Query however its a Monday morning and my brain will not work!
Any ideas would be great!
thanks