Sergey

I have a book called Transact-SQL. I cannot find how to suppress null values in my results like the VFP function NVL(). I also cannot find anything about creating UDFs, but it does cover stored procedures. Would you please explain further?

Thanks!

>>Thanks for that.
>>
>>Can we use this in-line to make a derived table?
>>
>>select somefield from sometable inner join (DECLARE @StrConcat varchar(8000)
>>SET @StrConcat = ''
>>SELECT somefield,@StrConcat = @StrConcat + ', ' + title_id
>> FROM sometable
>> GROUP BY somefield) dt_concat on sometable.somefield = dt_concat.somefield
>
>No.
>
>>Or should I create a procedure and call it as a derived field?
>
>Sproc cannot be used as derived field. You can try UDF though.