Extract data from Audit History

As soon as I posted this, I found another post which helped me:

Here is the full SQL, that I developed to extract the promised date from the AuditHistory and extract OrderType, OrderNbr and LineNbr.

SELECT
    ChangeID,
    ChangeDate,
    UserID,
    REPLACE(CAST(CombinedKey AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), '') AS CleanCombinedKey,
    LEFT(REPLACE(CAST(CombinedKey AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), ''), 2) AS OrderType,
    SUBSTRING(REPLACE(CAST(CombinedKey AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), ''), 3, 8) AS OrderNbr,
    SUBSTRING(REPLACE(CAST(CombinedKey AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), ''), 11, LEN(REPLACE(CAST(CombinedKey AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), ''))) AS LineNbr,
    TRY_CAST(
        SUBSTRING(
            REPLACE(CAST(ModifiedFields AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), '|'),
            CHARINDEX('PromisedDate|', REPLACE(CAST(ModifiedFields AS nvarchar(4000)) COLLATE Latin1_General_BIN, NCHAR(0), '|')) + LEN('PromisedDate|'),
            19
        ) AS datetime
    ) AS PromisedDateValue

FROM AuditHistory
WHERE TableName = 'POLine'
  AND CAST(ModifiedFields AS nvarchar(4000)) COLLATE Latin1_General_BIN LIKE '%PromisedDate%';