Tim

Are computed columns limited to "simple" SQL? What I'd like to do is put code in to produce a formatted column based on the data in 1 (or possibly 2) other columns in a table.

Ultimately the objective is to replicate

Trim(FormatMaskText(FormatMask + ';0', Numbers)) + ' ' + Alphas;

With FormatMask being selected depending on the first few characters of the input field. I can then store a field (its phone numbers)  without any spaces and display nicely formatted on screen/paper.

Roy Lambert

Roy,

<< Are computed columns limited to "simple" SQL? What I'd like to do is put
code in to produce a formatted column based on the data in 1 (or possibly 2)
other columns in a table. >>

They can refer to any built-in functions and any columns within the same
table.  Currently they cannot use UDFs, due to client-side restrictions for
remote sessions.

--
Tim Young
Elevate Software
www.elevatesoft.com