• Ah, I got it.

    Update Table1

    Set ColB = (Select Substring(ColA, 1, 1));

    This worked.

    Thanks.