In a query file, I would like to replace a character with a zero width space, to allow for line breaks. I tried
replace(myField, '/', U&'\200B') AS myNewField
But I get an error 'Could not resolve column: U'. Is there away to write a unicode constant in Labkey SQL? I'm sure I can accomplish this by adding Java code for column formatting, but doing it in a query would be much simpler....
The underlying DB is Postgresql, and I am still running Labkey v17.1
Thanks!
-Will |