This content has been marked as final. Show 5 replies
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 *