I want to sort a text field as if it was formatted as number. Is it possible to set the Data Type of an expression in a query? What I mean here is I have a field (Notice_ID) formatted as text that I want to remove the first two characters leaving the remaining number values only. Then I could sort based on numbers.
As an example, in my query I created an expression Notice_NO: mid([Notice_ID],3)
Any suggestions would be appreciated.