You are viewing a single comment's thread. Return to all comments →
SUBSTR(string, start, length)
or
SUBSTR(string FROM start FOR length)
So with 1st Length(city) it will start from the end of the city name.
With 2nd Length(city) it will take the complete city name(length of it, starting from the last or back).
Weather Observation Station 7
You are viewing a single comment's thread. Return to all comments →
SUBSTR(string, start, length)
or
SUBSTR(string FROM start FOR length)
So with 1st Length(city) it will start from the end of the city name.
With 2nd Length(city) it will take the complete city name(length of it, starting from the last or back).