query problem

• isa-369599

  SSCommitted

  Points: 1602

  More actions

  October 9, 2006 at 10:43 pm

  #90504

  Hello everyone,

  i have a

  table in sqlserver 2000, in this i have a column "Name" with the following data::

  Name

  Ali Sheikh

  Umer Aftab

  Waseem

  Vidya Balan

  now i want

  to write a query to get the first part of the name ,e.g my query return the follwing result:

  Ali

  Umer

  waseem

  Vidya

  and then

  i stored this in my new column "MiddleName",

  tell me the query plz

  its very urgent

  plz reply me asap.

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 10, 2006 at 8:09 am

  #665012

  cross posting.....

   

  select (case when charindex(' ',name) > 0 then substring(name,1,charindex(' ',name)) else name end) from your_table

   

   

  --Ramesh
  

  ---