• Jeff Moden (7/27/2013)


    iamsql1 (7/26/2013)


    Use length and then substring funtionc

    It's easy to get to the moon. All you need to do is build a rocket ship. 😉

    How would YOU use what you suggested to accomplish the task? Some code would be a big help.

    SUBSTRING(column, 3, len(column));

    Use Column name in first and last place of argument.