SWQL SELECT and TRIM results

sredmond

I am creating a SWQL for a Application Dashboard and I am wanting to trim characters for better visibility and sorting. 

SELECT

a.FullyQualifiedName AS [CertNode]

FROM Orion.APM.Application a

WHERE (a.Name = 'SSL Certificate Expiration Date')

All the results have "SSL Certificate Expiration Date on" before the node name. 

I want to remove 'SSL Certificate Expiration Date on' from a.FullyQualifiedName

thank you

sredmond

Here's the working solution with SUBSTRING

SELECT

SUBSTRING(a.FullyQualifiedName,36,charindex('on ',a.FullyQualifiedName)-1) AS [CertNode]

FROM Orion.APM.Application a

WHERE (a.Name = 'SSL Certificate Expiration Date')