How to put @ in SWQL result?

Could do something like:

KMSigma.SWI What's the SWQL stance on variables at the mo?

It works if you can define one, seems to be in the UI

Not a clue.  I'm not one of the architects.

I've never used it this way.

In a Baader-Meinhof phenomenon I'd never had this problem before, but had it today immediately after seeing this post. the behaviour is really weird. Seems to care about what comes shorly afterwards, terminating a string I suppose. If you cant slightly move stuff around to resolve it you can place it somewhere in the DB as data and then select to call it up.

You may also be able to escape the @ with the "\" character so your query would be something like:

SELECT TOP 50
'Asset Manager' AS [Full Name],
'example\@work.com' AS [Email],
N.Caption as [ItemName]

From Orion.Nodes N

Sorry I can't test it for you.

Unfortuantely that doesn't work...  It doesnt' like the "." in ".com" is seems.

While I didn't get the replace to work, it gave me what I needed to come up with a usable workaround.

Thanx,