maximus1974
asked on
How to place a delimiter using CONCAT
I need to place a pipe or vertical bar as shown below using the select statement also shown below:
1/1/2009|BLOCK AS PER CANCELLATION MEETING|6/21/2017
1/1/2009|BLOCK AS PER CANCELLATION MEETING|6/21/2017
SELECT [SQL]
,[PNM_AUTO_KEY]
,CONCAT(ISNULL(CREATION_DATE,','),ISNULL(NOTES,''),ISNULL(BLOCKED_DATE, '')) AS NOTES
,[Blocked]
,[CAP_AUTO_KEY]
FROM [QUANTUM_LIVE].[dbo].[MIN_MAX]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
CONCAT( ISNULL(CREATION_DATE,','),