The Weird and The Wonderful

<br />
SELECT  0 * Sum(IIf([amortisedClosePriceIssueYld]=0 Or [amortisedClosePrice]=0,0,-[bsqflag]*[closedq]*[valpoint]*([amortisedClosePriceIssueYld]-[amortisedtpissueyld]))) AS LocalRealisedAmortIssue<br />
FROM ((((PL1RPLCloseOuts INNER JOIN seclocal AS sec ON PL1RPLCloseOuts.id = sec.id) LEFT JOIN SecTypeValidationRuleslocal AS SecTypeValidationRules ON sec.sectype = SecTypeValidationRules.sectype) INNER JOIN TradeFundlocal AS TradeFund ON PL1RPLCloseOuts.fund = TradeFund.fund) INNER JOIN tradetlocal AS TradeT ON PL1RPLCloseOuts.tt = TradeT.tt) INNER JOIN PL1RplTaxlots ON (PL1RPLCloseOuts.tnum = PL1RplTaxlots.tnum) AND (PL1RPLCloseOuts.tt = PL1RplTaxlots.tt)<br />

private static string[] SplitByString(string testString, string split)
        {
            int offset = 0;
            int index = 0;
            int[] offsets = new int[testString.Length + 1];

            while (index < testString.Length)
            {
                int indexOf = testString.IndexOf(split, index);
                if (indexOf != -1)
                {
                    offsets[offset++] = indexOf;
                    index = (indexOf + split.Length);
                }
                else
                {
                    index = testString.Length;
                }
            }

            string[] final = new string[offset + 1];
            if (offset == 0)
            {
                final[0] = testString;
            }
            else
            {
                offset--;
                final[0] = testString.Substring(0, offsets[0]);
                for (int i = 0; i < offset; i++)
                {
                    final[i + 1] = testString.Substring(offsets[i] + split.Length, offsets[i + 1] 
                                   - offsets[i] - split.Length);
                }
                final[offset + 1] = testString.Substring(offsets[offset] + split.Length);
            }
            return final;
        }