Home Forums Reporting Services Reporting Services Retrieve data when there's only 1 '.' RE: Retrieve data when there's only 1 '.'

  • October 24, 2012 at 3:32 am

    #1552183

    davdam8 (10/24/2012)

    Hi geniuses.

    I got a report to build and I need data from a field which contains lots of junk data, like:

    MNN.helloworld

    SSD.goodbyeworld

    DDS.seeulaterworld.oops

    ....

    What I really need when there's only 1 '.' in the data.

    How do I Where this up?

    Thanks

    Regards

    Duplicate post. Replies here (http://www.sqlservercentral.com/Forums/Topic1376365-391-1.aspx) please.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/