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

  • December 15, 2013 at 9:32 am

    #1673545

    IgorMi (12/15/2013)

    shashianireddy (12/15/2013)

    again it shows error like

    Msg 537, Level 16, State 5, Line 1

    Invalid length parameter passed to the LEFT or SUBSTRING function.

    Now corrected, pls check it.

    select house_no

    from test1

    where

    len(house_no)>=6 and

    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