example: i have a number=143.42 , i want to get “4” which is locate 2 place before decimal point. what SQL command should i use? i still new in SQL, don’t roast me too hard.
You could do it with some simple math
SELECT 143.42 div 10 % 10;