Develop a standard header for stored procedures, views and user-defined functions. Include details such as a brief description of the object, specification document, author, date created, change history, etc.

Throughout the...

On the other if you were to use COALESCE you code could look like this

SELECT @PatientHospitalID = COALSESCE (LTRIM(RTRIM(@PatientHospitalID)), 0)

shorter and eaiser to read imho

Isn't Coalesce preferred over IsNull, being ansi standard and all? You wouldn't have had this problem anyway...

Aggregate concatenation... it's good to know what you are doing. So a big thank you for the links! And to the rest of for taking the time.

Sorry for being a tad unclear. It was this feature that I was wondering about. The function was just something I made to demonstrate it. When the select returns more...