Amanda Walshaw
asked on
Firstnames
issues with middle name
in one column I have a firstname and a middle name
Gwenda agnes
Pamela joyce
Jocelyn ruth
Gregory ian
Cheryl joy
and sometimes just one name
John
Where you have two names in the firstname column how do you get it to appear as
Gwenda Agnes
If there is only one space between the next name?
in one column I have a firstname and a middle name
Gwenda agnes
Pamela joyce
Jocelyn ruth
Gregory ian
Cheryl joy
and sometimes just one name
John
Where you have two names in the firstname column how do you get it to appear as
Gwenda Agnes
If there is only one space between the next name?
ASKER
sorry page not found
ASKER
sorry its taking me to an advertisment about registering in San francisco
ASKER
-update Staging_mytable
set firstname = Replace(Firstname,reverse( left(rever se(firstna me),len(fi rstname)-1 )), reverse(lower(left(reverse (firstname ),len(firs tname)-1)) )) ,
I have used this query but I am getting struck by the middle name, it is consistent with one space.
set firstname = Replace(Firstname,reverse(
I have used this query but I am getting struck by the middle name, it is consistent with one space.
i have copied the script into .txt file from the link .... its a same link that PortletPaul has posted.
notepad.txt
notepad.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
update dbo.mytable
set firstname = Replace(Firstname,reverse left(reverse(firstname),le n(firstnam e)-1)))) + ' ' + reverse(lower(left(reverse (firstname ),len(firs tname)-1)) )
where Firstname = 'Kym dianne'
and LastName = 'Spoors'
unfortunately getting error message
The replace function requires 3 argument(s).
set firstname = Replace(Firstname,reverse left(reverse(firstname),le
where Firstname = 'Kym dianne'
and LastName = 'Spoors'
unfortunately getting error message
The replace function requires 3 argument(s).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So much for "no points please". Oh well ...
link