Home Forums SQL Server 2005 SQL Server Newbies Comparing 2 Columns until the 1st "." RE: Comparing 2 Columns until the 1st "."

  • February 7, 2014 at 12:12 pm

    #1687192

    qta-subbld4-swt1-ups1qta-sub-bldg4-swt1-ups1.domain<-should show

    qta-lr-china-hssp-ups1qta-china-hssp-ups1.domain<-should show

    sha-cab67-ups1.domainsha-cab67-ups1.domain<-should NOT how, but does

    sha-cab78-ups1.domainsha-cab78-ups1.domain<-should NOT how, but does

    sha-cab4009-pdu1.doaminsha-cab4009-ups1.domain<-should show

    There you go

    Thanks