SWQL Trim Syntax

Unfortunately this function is not implemented, as far as I know (SWQL Functions · solarwinds/OrionSDK Wiki · GitHub ). If you know the max length of the formated string, you may use the substring (I know, it's not exactly the desired functionality) function or eliminate the source of the spaces (e.g. if the formated string contains the spaces, than use SQL update to trim them). If nothing fits to you, I could potentialy create feature request for you, but can't guarantee the timeframe of implementation.

H.

Trim function would be a nice feature add. I worked around it using substring as you suggested. Thanks!

I'm glad it helped. Feature request created (for reference tracked under CORE-7886)