Double Quotes

SQL

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

                       

  • 0
  • 0
  • 59
  • 2
  • 2

Answers

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

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

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

""""_tect_"""" 

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

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