Hello,
I will be importing the text data to SQL and there is a state column with the values of (4) MD. I want to seperate the Code(4) into code column and MD into code description colum. How would I do that. I know you can use the derive column, but I am not sure about the expression. Can some one please help me? Thanks a bunch!