|
|
Posted by othellomy on 03/12/07 07:02
On Mar 9, 2:20 pm, "portCo" <woos...@gmail.com> wrote:
> Hi there,
>
> I am re-organizing the database. We used to have field 'names' in our
> table for our first name and last name. However, I want to have those
> names in different field.
>
> FYI, I have two different tables in different databases. The A
> database contains A table with 'names" field. The B database contains
> B table with 'fname' and 'lname' I want to copy data A table to B
> table.
>
> How can I parse names field into first name and last name fields?
>
> Here are some examples which are in the database.
> (
> id names
> 01 John Doe
> 02 John & Jane Doe
> 03 Mr & Mrs Doe
> ) something like this. It might contain '&' and two names. If there
> are two names, then use first name.
>
> Thanks guys,
hi,
select id,
fname = substring(ltrim(rtrim(names)),1,charindex('
',ltrim(rtrim(names))) - 1),
lname = reverse(substring(reverse(ltrim(rtrim(names))),
1,charindex(' ',reverse(ltrim(rtrim(names)))) - 1))
from Atable
HTH
Navigation:
[Reply to this message]
|