Home Forums SQL Server 2005 T-SQL (SS2K5) displaying records only if both the values of a field are avaliable RE: displaying records only if both the values of a field are avaliable

  • Nothing is displayed the way you have tried because you are saying:

    'Give me all rows where col1 is d and col1 is i'

    Col1 cannot simultaneously contain both values - hence no data is returned.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.