Closed. This question needs debugging details. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 1 year ago. Improve this question 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