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
What format is your data table in? What software are you using for running this SQL query?
In any case, take a look at the info here. This might help:
Its in an oracle database, I want to reproduce a Functional Attribute from an Intergraph geoworkspace.
I need to use FIND,LEFT,RIGHT functions to compile the result