handle data which contains space

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  July 25, 2013 at 4:10 am

  #276245

  Hi all,

  I am having table JobDetail whcih contains jiobname as a one of column.here the data entered from front end is not correct because of space issue.

  for example if job name is Software engineer then it might be entered single space or sometimes multiple spaces between "Software" & "engineer". but while selecting i want only once.I am using distinct but giving wrong output. Please suggest any idea.

  thanks

  Abhas

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 25, 2013 at 4:45 am

  #1635661

  You can first cleanse the data by replacing the multiple spaces by one.

  This article has an excellent method on doing this efficiently:

  REPLACE Multiple Spaces with One[/url]

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP