0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT Site = LEFT(LEFT( 
                    RIGHT (name, LEN(name) - CHARINDEX('.',name) ),
                    CHARINDEX('.',RIGHT (name, LEN(name) - CHARINDEX('.',name) ))
                    ), LEN(LEFT( 
                    RIGHT (name, LEN(name) - CHARINDEX('.',name) ),
                    CHARINDEX('.',RIGHT (name, LEN(name) - CHARINDEX('.',name) ))
                    ))-1)
FROM sys.databases 
WHERE Name like '%StackExchange.%' 
      and LEFT( 
                RIGHT (name, LEN(name) - CHARINDEX('.',name) ),
                CHARINDEX('.',RIGHT (name, LEN(name) - CHARINDEX('.',name) ))
               ) NOT like ''

fork query

edited may 6 14

created may 6 14 AsheeshR