I am trying to update a varchar column with a string of SQL as the value and I am getting errors.
for example
update t1
set t1.sqlcolumn = 'INSERT into t2 select case when t3.sqlcolumn in not null then t3.sqlcolumn else 'N/A' end'
The 'N/A' part is where I am gettng the error, am I supposed to use double quotes?
thanks in advance
for example
update t1
set t1.sqlcolumn = 'INSERT into t2 select case when t3.sqlcolumn in not null then t3.sqlcolumn else 'N/A' end'
The 'N/A' part is where I am gettng the error, am I supposed to use double quotes?
thanks in advance