• DECLARE @t VARCHAR(15)

    SET @t = '111.222.333.444'

    SELECT PARSENAME(@t,4),PARSENAME(@t,3),PARSENAME(@t,2)

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg