Query Help

• yogi123

  SSCrazy

  Points: 2932

  More actions

  July 3, 2013 at 8:24 am

  #275861

  Hi All

  I need one logical help to implement in my main logic.

  so please help me to do

  create table #x1

  (SchoolID int,

  SchoolName Varchar(50))

  INSERT INTO #x1 VALUES (101,'CITY CONNECTIONS-WEST')

  INSERT INTO #x1 VALUES (102,'City Connections - South')

  I need space around hyphens where SchoolName has no space around Hyphes.

  SchoolIDSchoolName

  101CITY CONNECTIONS-WEST

  102City Connections - South

  Expected output is as below

  SchoolIDSchoolName

  101CITY CONNECTIONS - WEST

  102City Connections - South

  Please help me to do this

  Thanks for Your Help

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  July 3, 2013 at 8:28 am

  #1629550

  SELECT SchoolID

  ,REPLACE(REPLACE(SchoolName, '-',' - '),' - ',' - ') AS SchoolName

  FROM #x1

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• mickyT

  SSChampion

  Points: 10360

  More actions

  July 3, 2013 at 2:01 pm

  #1629659

  Eugene Elutin (7/3/2013)

  ---

  SELECT SchoolID

  ,REPLACE(REPLACE(SchoolName, '-',' - '),' - ',' - ') AS SchoolName

  FROM #x1

  Hi

  Unfortunately this will leave double spaces for strings like 'One -two'

  A little change

  SELECT SchoolID

  ,REPLACE(REPLACE(SchoolName, '-',' - '),' ',' ') AS SchoolName

  FROM #x1