Home Forums SQL Server 2005 SQL Server 2005 General Discussion String search RE: String search

  • July 15, 2008 at 10:24 pm

    #843493

    You can also user TALLTY Table in this case.

    Thiswill parse your string character wise. Parsing can also be done by many ways, but 'tally table' strategy is fast.

    After parsing the string character wise, you can use ISNumeric function and get the desired results.

    Here is the link... Might be helpful for future use.

    http://www.sqlservercentral.com/articles/TSQL/62867/">

    http://www.sqlservercentral.com/articles/TSQL/62867/

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]