Home Forums SQL Server 2008 T-SQL (SS2K8) string manipulation - Need help ! RE: string manipulation - Need help !

  • September 4, 2012 at 1:42 pm

    #1533489

    Can you explain more your requirements?

    Because I'm sure that this won't work for you.

    SELECT inputString, SUBSTRING( inputString, 1,42) + SUBSTRING( inputString, 105,16)

    FROM (SELECT 'BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator]' AS inputString) Input

    However, it gives the correct output.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2