Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field in the database that is a nvarchar (sql server) with the value
J & A Services Inc/Painting & Design
When it is displayed in qlik it is showing up as
J & A Services Inc/Painting & Design
How do I fix this?
Hi,
I think this is more a SQL case than a Qlik case.
Try to use this to get rid of the problem before you extract to Qlik.
select @str = replace(@str, '&', '&')
https://stackoverflow.com/questions/10618211/why-does-sql-display-an-as-amp
Brgds