separate space delimite field

• Frances L

  SSCarpal Tunnel

  Points: 4727

  More actions

  April 27, 2007 at 9:12 am

  #172217

  I have a field data like this 1648 Huntingdon Pike which separet by space.

   

  I tried to use this select query to return 1648 Huntingdon

   

  select  CHARINDEX(PName, '  ' ) , PName  from DoctorMaster

   

  select  CHARINDEX(PName, space(1) ) , PName  from DoctorMaster

  I do not know why CHARINDEX(PName, '  ')  return 0.

  select substring(PName,  1, CHARINDEX(PName, space(1) ) ) , PName  from DoctorMaster

   

  I use the above substring return nothing on substring(PName,  1, CHARINDEX(PName, space(1) ) ) ,

  Thx.

   

• Omri Bahat-433962

  SSC Eights!

  Points: 901

  More actions

  April 27, 2007 at 9:16 am

  #702969

  You got the parameters in the CHARINDEX backwards. THe space should be the first param.