5 Replies Latest reply: Oct 27, 2014 11:59 AM by Mark O'Donovan RSS

    "null" value to "1"

      Hi all,


      I have SQL table, how to set up , if the value is " null " written 1. Using my script i'm i get value "-"






      LOAD ID as [item.ID],

          Name as [pr.name],

          Code as [pr.code],

          TareWeight as [pr.twt],

          if ((TareWeight='Null') or (TareWeight=0),1,TareWeight) as [Weight]


      SQL SELECT *

      FROM postgres."public".erpoitm