• Ummm. Why don't you just run a substring starting from the first position? That looks a lot easier then this.

    SUBSTRING(<string here>,1,<length here>)