join with table data

Community Support
1

table1: ( tid: int$(); tdesc: $())table1 insert 1, test1want to add * in the desc but ‘,’ does not work in sqlselect tdesc,“*” from table1

2

I can’t think of a more elegant approach, but this works:update tdesc:{$string[x],"\*"}'[tdesc] from table1On Aug 27, 3:54?am, kittu <nitinvi...> wrote:&gt; table1: ([] tid: int$(); tdesc: $())&gt;&gt; table1 insert 1, `test1>> want to add * in the desc but ‘,’ does not work in sql>> select tdesc,“*” from table1</nitinvi…>

3

Can be slightly simplified to

update tdesc:(`$string[tdesc],'“*”)from table1

Note that if the additional string is more than one character you need
,: not ,’