parsename

• swekik

  SSC-Addicted

  Points: 486

  More actions

  May 25, 2008 at 12:59 am

  #185992

  I am getting some problem in using parsename fuction,if my login name is DOMAIN\firstname.lastname,it is displaying only the last name,but i want to display as firstname.lastname.

• Jeff Moden

  SSC Guru

  Points: 1004579

  More actions

  May 25, 2008 at 10:00 am

  #820067

  One simple forumla will return correctly whether the domain is present or not...

  DECLARE @MyDomainName SYSNAME

  SET @MyDomainName = 'firstname.lastname'

  SELECT SUBSTRING(@MyDomainName,CHARINDEX('\',@MyDomainName)+1,128)

  SET @MyDomainName = 'DOMAIN\firstname.lastname'

  SELECT SUBSTRING(@MyDomainName,CHARINDEX('\',@MyDomainName)+1,128)

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)