AttribDescription As Calculated Field

Hi

in T-SQL,

(how) is it possible to concatenate 3 (varchar) fields into one; either
in a SQL query or through a calculated field (or using a view, if
anybody can explain to me how to use views), according to the following
rules:

{
first 30 chars of Trim(AttributeVal1)

if resulting string<30 chars append
", " & first 30 chars of Trim(AttributeVal2)

if resulting string<30 chars append
", " & first 30 chars of Trim(AttributeVal3)
}
=> define as new field StockItemDescription

ideally I would like SQL Server to do this processing rather than
building all these answer strings on the client side.

tia
Axel