• ScottPletcher (10/8/2012)


    SELECT lastname

    FROM HR.Employees

    WHERE

    lastname LIKE '%[/]%' AND

    lastname NOT LIKE '%[/]%[/]%'

    Still have to add the line that removes / in the first character. I also believe you would want to remove any where / was the last character...

    And Left(Ltrim(LastName), 1) <> '/'

    And Right(Rtrim(LastName),1) <> '/'

    I'm curious if this would not be a good option from an execution plan perspective? Are there better / faster ways of completing this?

    [font="Arial"]“Any fool can know. The point is to understand.”
    - Albert Einstein

    "DOH!"
    - Homer Simpson[/font]