First beta of  Advanced ETL Processor Professional is available for Download

New Advanced ETL Processor Pro Documentation is available for download
It has 242 pages and provides all the information you need to use it

declare @x varchar(10)
set @X='1245-XMCD-GTH'
select Right(substring(@X,charindex('-',@X)+1,charindex('-',@X,charindex('-',@X)+1)-charindex('-',@X)-1),2)

Hint:
    There result is last two characters of a middle part -‘CD’

Now answer those two questions

• How long did it take you to figure out the result?
  What is the chance of writing wrong code or getting an error?
  Can you apply same function to a text file, Oracle table or in fact any table?

Visual Importer Enterprise version 7.5.15 is available for immediate download.

Changes are:

• Minor bugs fixes
• Import script interface improvements