Home Forums SQL Server 2008 SQL Server 2008 - General How will get distinct records in SQL table? RE: How will get distinct records in SQL table?

  • December 28, 2013 at 5:15 am

    #1676207

    Would you mind being a little more specific?

    What is the "business logic" to get to the result you're looking for?

    It's unknown, whether the value is "2.Test." or "Test.".

    It is also unknown, whether you're looking for identical characters at position 3 to 7 (or 1 to 4, respectively), or for the substring "Test", regardless of the position within the string itself.

    Please help us help you.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]