Need SQL to strip off anything to right of slash

• Express12

  SSCoach

  Points: 18514

  More actions

  July 13, 2009 at 9:22 am

  #139807

  Looking for SQL to render a string that truncates anything to the right of the character "\"

  3 examples:

  1) ServerName1\Dev should render as ServerName1

  2) SN1\Development should render as SN1

  3) ABCD\1234 should render as ABCD

  any suggestions are greatly appreciated...

  BT

• ps.

  One Orange Chip

  Points: 29422

  More actions

  July 13, 2009 at 9:31 am

  #1023966

  declare @str1 varchar(100)

  set @str1='ServerName1\Dev'

  select left(@str1,charindex('\',@str1)-1)

  I've assumed there is only one backslash in the string!!

  ---

  
  Pradeep Singh

• Doylie

  SSC Eights!

  Points: 829

  More actions

  July 13, 2009 at 9:37 am

  #1023974

  Try this...

  CREATE TABLE #tempa

  (

  idcol INT IDENTITY(1,1),

  NAME VARCHAR(100))

  INSERT INTO #tempa (NAME)

  SELECT 'ServerName1\Dev'

  INSERT INTO #tempa (NAME)

  SELECT 'SN1\Development'

  INSERT INTO #tempa (NAME)

  SELECT 'ABCD\1234'

  SELECT SUBSTRING(NAME,1,CHARINDEX('\',NAME,1)-1) FROM #tempa