Post reply

How to display the part of the string after ':'

  • October 29, 2008 at 7:57 am

    #195261

    I need to display the part of the string 'Governmental - Facilities: 1000-70202-60200',

    so the expected result is '1000-70202-60200'

    In Oracle, I assume I would use substr and instr functions.

    Please give the idea how to solve the problem in SQL Server?

    Thanks

  • October 29, 2008 at 8:40 am

    #891257

    I have found solution,

    using functions substring and charindex

    Thanks

  • November 5, 2008 at 8:40 am

    #894295

    A+ for keeping at it.

    The more you are prepared, the less you need it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply