I am creating a view in Rbase 8 with a computed column. I am trying to give the computed column an ALIAS for easier reference, but haven't figured out the syntax for that. This creates the view ok, but it gives a long column name. CREATE VIEW 'TrialLayout1' AS SELECT + T1.Trial, + T2.entry, + T3.PlotNum, T3.Entry, T3.RepNum, T3.blockNum, + ((INT(trial)*10000 + PlotNum)) + FROM trialNo T1, trial T2, Randomization T3 + WHERE + T1.trial = T2.trial AND T1.randNum = T3.randNum AND T2.entry = T3.entry How would I assign an alias "TRIALPLOT" to the computed column ((INT(trial)*10000 + plotnum)) ? Thanks. Bill

