Dynamic SQL select query is not working

[khalidinio]

How do I need to replace a "non-breaking space" to a normal space? Something like this?

OLD sql query:

Select ID
From dbo.PersonType
Where Name = '{ItemProperty:VeroorzakerSoort}'

New sql query:

Select ID
From dbo.PersonType
Where Name = 'fn-Replace({ItemProperty:VeroorzakerSoort}, , )'

[emha]

I'd suggest to do it in a separate action (set variable, build string...), store result to a variable and then reference variable in the SQL.

I guess, the way, you depicted it, nintex will misundersatnd meaning of apostrophes and take fn-replace() literally, not as a function.

the other advantage is that you can then write variable into a log to check what exactly is supplied to the SQL.

[khalidinio]

I created a new workflow variable. I created a new action to set the value of this variable. In this action I do:

this is logging to the history:

The middle space is a normal space. The first and thirs space is the non-break space. How can I replace the non-break space?

[emha]

try to insert non breakable space character into formula as ALT+0160