Home Forums SQL Server 2008 T-SQL (SS2K8) How to grab characters before and after a string RE: How to grab characters before and after a string

  • August 17, 2012 at 12:44 am

    #1526917

    This is on the same lines but a little different in logic:

    Select LEFT([Flammables/solvents], (CHARINDEX('/', [Flammables/solvents]) - 1) ) As Flammables,

    RIGHT([Flammables/solvents], (CHARINDEX('/', Reverse([Flammables/solvents])) - 1) ) As Solvents

    From Ex

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉