sql - Convert from double to string in STATISTICA query node -

EDIT: We have decided that, instead of the syntax issue, it is probably a bug . For now I found the data connected to the query string node using the ToString (x) in the transform node.

I need to convert a variable from double to string (or unsuccessful in some text data type), a STATISTICA query node - node which you can use to ask other workspace nodes in the workspace . Apparently this is Oracle SQL, but anything I've been found / found working online:

  Four (x), string (x), text (x), cast (X as four), cast (string as x), cast (x as text), TO_CHAR (x), to_string (x), to_text (x),  

< P> Here is the original SQL (edit b / c security):

  select tbl1.var, tbl2.Lot_Number_1, tbl3.var2, tbl4.Lot_Number_2, tbl5.var2, tbl6.Lot_No_3 , Tbl7.var2, tbl8.Lot_No_4, tbl9.var2, tbl10 .Lot_Number_5, tbl11.var2, tbl12.Lot_Number_6, tbl13.Lot_Number_7, tbl14.var2 [All tables;  

And here's where I try to use one of the above on a number of variables:

  SELECT tbl1 Var, cast ( Tbl2.Lot_Number_1 as string), tbl3.var2, tbl4.Lot_Number_2, tbl5.var2, tbl6.Lot_No_3, tbl7.var2, tbl8.Lot_No_4, tbl9.var2, tbl10.Lot_Number_5, tbl11.var2, tbl12.Lot_Number_6, Tbl13 .Lot_Number_7, tbl14.var2 [All tables; I get an inner - doing fine thing]  

This is the error message I have:

  "error with node '[node name]': pars Error expecting token: & lt; COMMA & gt; from & gt; final token: from '(' l '),' to_string '(p) last node:'. ColumnName: TableName {identifier or *} '- ---- -Press trace ------- Select identifier -> TableName DOT> Identifier identifier -> Identifier identifier - & gt; identifier_cots Valid identifier_cotenavailable -> Identifier_cot (No error in writing SelectExpressio) 
 
 
 
 
 
 
 
 
 
 
 
 P> thanks