Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

John Griffiths http://www.red91.com

1 total

On This Page:

  1. 1 get firstname and surname from string

get firstname and surname from string

to sql filter surname firstname by indiehead on Jan 15, 2007
// takes a string and rips out the firstname and surname from it

select 
substring(login_id, 1, patindex('% %', login_id)) as firstname,
substring(login_id, patindex('% %', login_id), len(login_id)) as surname

from c_contact
and login_id <> ''
1 total

On This Page:

  1. 1 get firstname and surname from string