Double Quotes

Question

Question

Lou Pizza · Oct 11, 2018

Hi,

I am trying to have the output of a field in sql have double quotes around them. The script is in Studio and I am accessing It through a task.

I have tried """"tect"""" and others...Please help

Aloha

Lou

Discussion (4)0

Log in or sign up to continue

Robert Cemper · Oct 11, 2018

In SQL you do SELECT '"'||field||'"' ....

String delimiter in SQL are single quotes ' String concatenator is || Double pipe

1 0

Robert Cemper · Oct 11, 2018

if you do it in object Script you just missed the concatenation operators (Underscore) _

""""_tect_""""

0 0

score 0 · Answer 1 · 2018-10-11T18:43:50-04:00

Robert, thank you so much> Now I am getting an invalid OREF error. whey I just hve text and not the pipes and quotes it runs fine.

Aloha

Lou

score 0 · Answer 2 · 2018-10-12T03:26:37-04:00

It would be useful to have a wider context of your problem.
invalid OREF may have many reasons and it's not obvious how this relates to your initial problem