5 Replies Latest reply: Dec 7, 2015 8:52 PM by Mr Loke RSS

    Qlikview  - SQL replace statement error

    Mr Loke

      Hi,

      In SQL 2012, I'm using the replace query as shown below with no problem. However, when I used in the script editor, it returned an error in Qlikview.

       

      select

      t.tpc_num,

      replace(t.tpc_subject, ',',' '),

      t.create_time,

      t.closed_time,

      s.status_name,

      m.mpt_num,

      c.item_type

      FROM tpc t WITH(NOLOCK);

       

      Please assist.

       

      Thanks.