Home Forums Programming General Between statement but like clause using wildcard RE: Between statement but like clause using wildcard

  • October 7, 2015 at 7:51 pm

    #1832191

    Instead of

    WHERE Primary_Diagnosis between 'C00%' and 'C14%'

    Just have :

    WHERE Primary_Diagnosis >='C00'

    AND Primary_Diagnosis <= 'C1499999'