This content has been marked as final. Show 2 replies
i need some help. My problem is:
i have a field/colum names TEST that contains for example:
I want now a table, that contains A, 1 or 12, r/s as columns.
I tried left(TEST,1) as column1,
mid(TEST,3,1) as column2,
right(TEST,1) as column3.
My problem is now, that the value 12 in column is showed as 1 because of mid(TEST,3,1).
How can i change the function to show the value 12?
Thank you for your help!