Home Forums SQL Server 2008 SQL Server 2008 - General Retrieve data between 2 '.' RE: Retrieve data between 2 '.'

  • October 25, 2012 at 8:24 am

    #1552717

    Davin21 (10/25/2012)

    How about this?

    SELECT *

    FROM #testenvironment

    WHERE PARSENAME(CAST(yourdata AS NVARCHAR(MAX)),3) IS NULL

    I had the same idea, but I added an extra condition because your query will return results with no period (or dot) and with more than 3.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2