Need help with SWQL statement

Hi all,

I am populating a servicenow action with the CI name with caption field  from orion.nodes. Unfortuantely in SNOW all the CI's use shortname so when a FDQN is used it doesnt populate. Is it possible to use regex in a swql or sql query to return just the shortname? ^([^.]*) should return everything up to but not including the (.) but i dont know how to implement this.