I have a field with number values (111,112,113,211,212,....) and want to extract only the first digit (111 -> 1, 259 -> 2 etc.).
I remember that there was some easy way to do that in field calculator, but not which it was.
Can anyone help?
I don't want to use
CASE WHEN, since I have roughly 100 various numbers.