I'm trying to convert a string of numbers and letters on a query, which happen to appear as: (000000000L). The field comes from a table which displays a mix of 0's and a letter at the end of the string.
I'm trying to convert this into a number/value such as (-1, -2, 1, 2, etc.)
Is there any type of function I can use in an expression for this?
I'm trying to convert this into a number/value such as (-1, -2, 1, 2, etc.)
Is there any type of function I can use in an expression for this?