How to Get the Required Output

• sandeepivs

  SSC-Addicted

  Points: 494

  More actions

  July 20, 2011 at 4:18 am

  #240183

  Hi Friends,

  I have a table consists of A Column which comprises of following values

  'sachin Tendulkar'

  'kapil Dev'

  'venkatesh prasad'

  'shoiab akthar'

  'ravi shastri'

  The Output should be a computed column having the following values

  ST

  KD

  VP

  SA

  RS

  Please help me out how do i make it..

  Let me know ASAP. Waiting for your Reply.

  Thanks In Advance,

  Sandeep IVS

• Tim Cooke

  SSC Veteran

  Points: 273

  More actions

  July 20, 2011 at 5:18 am

  #1355466

  Try this for size...

  USE [SandBox]

  GO

  IF OBJECT_ID('tempdb.dbo.#TESTNames') IS NOT NULL

  DROP TABLE #TESTNames

  CREATE TABLE #TESTNames (

  name VARCHAR(100) NULL,

  initials AS (UPPER(LEFT([name],(1))+SUBSTRING([name],CHARINDEX(' ',[name],(1))+(1),(1))))

  )

  INSERT #TESTNames(name)

  VALUES ('sachin Tendulkar'),('kapil Dev'),('venkatesh prasad'),('shoiab akthar'),('ravi shastri')

  SELECT * FROM #TESTNames

  Tim

• Tim Cooke

  SSC Veteran

  Points: 273

  More actions

  July 20, 2011 at 5:22 am

  #1355467

  You possibly want to add a REPLACE in there as well to deal with possibility of double spaces.

  initials AS (UPPER(LEFT([name],(1))+SUBSTRING(REPLACE([name],' ',' '),CHARINDEX(' ',[name],(1))+(1),(1))))

  Cheers

  Tim

• sandeepivs

  SSC-Addicted

  Points: 494

  More actions

  July 20, 2011 at 5:37 am

  #1355482

  Thanks A Lot Tim 🙂