Search results

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...