INSERT INTO tblSWJournal
(tblSWJournal.Ledger,
tblBulkPurchases.Amt)
SELECT 
CONVERT(varchar(30),INSERTED.HeatTicketNumber) 
+ ':' 
+ CONVERT(VARCHAR(30),INSERTED.PO_Number),
INSERTED.Unit_Price
FROM INSERTED

GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[trPopulateJournalEntries]
ON [dbo].[tblTransactions]
AFTER INSERT
AS
  BEGIN
    INSERT INTO tblSWJournal
                (tblSWJournal.Ledger,tblBulkPurchases.Amt)
    SELECT
      CONVERT(VARCHAR(30), INSERTED.HeatTicketNumber) + ':' + CONVERT(VARCHAR(30), INSERTED.PO_Number),
      INSERTED.Unit_Price
    FROM   INSERTED
    WHERE  INSERTED.Transaction_Type = 'From Bulk Assignment'
  END
GO 

SELECT 
	LEN(ColumnName) AS StringLength
FROM 	
	TableName
ORDER BY
	StringLength DESC