AnsweredAssumed Answered

generate a new column on a table

Question asked by john.woollett11 on Nov 29, 2016
Latest reply on Nov 29, 2016 by MidnightYell2003

I have a data table and want to perform an sql query to build a new column on the data containing data from several data columns, how can this be done?

 

eg  IF(FIND('-',Location_Code)=4, LEFT(Location_Code, 12), LEFT(Location_Code, 13))

 

thanks  john woollett

Outcomes