I am trying to import into SQL Server 2008 R2 a list of strings as follows:
I need to split the strings so they are inserted into separate fields. One of the substring statements is:
'SUBSTRING(xlCode; 15; 2) [if the second position is a number, and]
'SUBSTRING(xlCode; 15; 1) [if the second position is anything else]
My experience with T-SQL is just not enough to figure this one out. Can you tell me how the statement should be set up?
Thanks in advance for any help.