Thanks for your reply, Alan.B.

I posted the same topic under the forum 'SQL Server 2008 - General' and got the answer I was looking for.

Here's the topic link:

http://www.sqlservercentral.com/Forums/Topic1432866-391-1.aspx?Update=1

Thanks for...

Hi MickyT,

Thanks for your help.

This is what I needed, and I got there with your reply.

CASE WHEN substring(xlCode, 16, 1) LIKE '[0-9]' THEN substring(xlCode, 15, 1) ELSE substring

...