DECLARE @site VARCHAR(10)
SET @site='test_123'
Select Substring(@site,0,CHARINDEX('_',@site))
Select Substring(@site,CHARINDEX('_',@site)+1,Len(@site))
SET @site='test_123'
Select Substring(@site,0,CHARINDEX('_',@site))
Select Substring(@site,CHARINDEX('_',@site)+1,Len(@site))