trim last character if not a number

Question

I'm trying to trim out the last charater from a string if not a number For example : 2+3-4* From there last astrik needs to be trimmed as it is not a number my result should be as 2+3-4. If user enters 2+3+8 then no needs to trim as the last is number.

Ben Chris · Answer

if (!char.isDigit(stVal[stVal.Length-1])) { stVal = stVal.substring(0 stVal.Length-1) ; }

Amit Gupta · Answer

You can check by using char.IsNumber (..) if the last part is not a number then substring it.

Rafnas T P · Answer

try this select case when isnumeric( substring (reverse( ' YourSting ' ) patindex( '%[^0-9]%'  reverse( ' YourSting ' )) 1))!=1 then LEFT ( ' YourSting ' DATALENGTH( ' YourSting ' )-1) else ' YourSting ' end as newstr