Stripping a string

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  October 22, 2004 at 1:59 pm

  #84481

  Hey Guru's

  Quick question.  I have several a database with several names and email addresses.  Some of the email address are with a name.  Just for the purpose of a query I would like to populate the name field with the string of an email prior to the @ symbol (only the name field is null)

  Ex.

  wow@there.com

  I would like to strip "wow" and put it into the name column if the name value is null

  I hope this makes sense.  Thanks

  Shane

• Aaron Templeton

  SSCarpal Tunnel

  Points: 4655

  More actions

  October 22, 2004 at 2:24 pm

  #527716

  ISNULL( name, case when CHARINDEX('@', email, 1) = 0 then '' else LEFT(email, CHARINDEX('@', email, 1) - 1) end ) AS name