Home Forums SQL Server 2012 SQL Server 2012 - T-SQL select quarie between houseno .......... RE: select quarie between houseno ..........

  • December 15, 2013 at 7:29 am

    #1673523

    OK,

    What about this?

    select house_no

    from YourTable

    where house_no between '4-12-1000' and'4-12-1500'

    and SUBSTRING(house_no,6,10) not like '%[^0-9]%'

    Igor Micev,My blog: www.igormicev.com