Combine Multiple rows into single column using FOR XML

TABLE DATA

ORDERNUM	SEQNUM	note
00000001	1	PLEASE ADVISE MARY ANN WHEN READY FOR
00000001	2	CUSTOMER PICK UP
00112216	1	Use 52' Reefer
00112217	1	Call for delivery appointment
00112218	1	Deliver to stock room
00112219	1	Must ship by:  10/20/04
00112220	1	Call for delivery appointment
00112221	1	Ship via reefer
00112223	1	Smile at the driver
00112224	1	Smile at the buyer

SQL

WITH orderNotes(ORDERNUM,notes) AS
(
SELECT DISTINCT
	rtrim(ltrim(a.ORDERNUM)),
	stuff((SELECT
			', ' + 
				CASE WHEN b.SEQNUM = 100 THEN
				'<b>' + CONVERT(VARCHAR,b.SEQNUM) + ' - ' + rtrim(ltrim(b.note)) + '</b>'
				ELSE
				CONVERT(VARCHAR,b.SEQNUM) + ' - ' + rtrim(ltrim(b.note))
				END
			FROM
			NOTES b
			WHERE b.ORDERNUM = a.ORDERNUM ORDER BY SEQNUM
        FOR xml path('li')),1,1,'< ') AS notes
FROM
	NOTES a 
)
SELECT * FROM orderNotes ORDER BY ORDERNUM

OUTPUT

ORDERNUM	notes
00000001	<li>, 1 - PLEASE ADVISE MARY ANN WHEN READY FOR</li><li>, 2 - CUSTOMER PICK UP</li>
00112216	<li>, 1 - Use 52' Reefer</li>
00112217	<li>, 1 - Call for delivery appointment</li>
00112218	<li>, 1 - Deliver to stock room</li>
00112219	<li>, 1 - Must ship by:  10/20/04</li>
00112220	<li>, 1 - Call for delivery appointment</li>
00112221	<li>, 1 - Ship via reefer</li>
00112223	<li>, 1 - Smile at the driver</li>
00112224	<li>, 1 - Smile at the buyer</li>

via: http://davidduffett.net/post/5334646215/get-a-comma-separated-list-of-values-in-sql-with

Screen Shortcuts from MPE command prompt

All the MACS short cuts are listed in the COMMANDS group or in the MACS UDCS.
 
ACTLMACS		Advertising Control 
ADVRMACS 		Advertising Analysis
ASMBMACS 		Assembly Main menu
ASSEMBLY    		Ditto
BACKMACS 		Back order management
CCMACS   		Credit Card Management
CNMACS   		Continuity
CYCLMACS 		Cycle Counting Screen
FCTLMACS 		Financial Control Menu
FINAMACS 		Financial Analysis Menu
INMACS   		Installment Billing Menu
JOBSMACS 		Production Processing menu
MCTLMACS 		Merchandising Control menu
ORDRMACS 		Order Control
POSMACS  		Point of Sale main menu
PRODMACS 		Production analysis
PURCMACS 		Purchasing Management
SHIPMACS 		Shipping control menu
WCTLMACS 		Warehouse management menu
WHSEMACS 		Warehouse analysis