|
Look at the MS SQL Server code below and think what it will return 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 |
|
Read more... [Why Use ETL]
|