Double Quotes
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
Comments
In SQL you do SELECT '"'||field||'"' ....
String delimiter in SQL are single quotes ' String concatenator is || Double pipe
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
if you do it in object Script you just missed the concatenation operators (Underscore) _
""""_tect_""""
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