Viewing 7 posts - 16 through 22 (of 22 total)
Oh crap. After looking at the table more closely the format isn't consistent. I have some that have their whole middle name instead of initial, some that have...
October 16, 2008 at 10:45 am
Well I tried to run this portion of your script against the existing table:
SELECT Fullname,
LEFT([FullName],CHARINDEX(',',[Fullname])-1) AS LastName,
...
October 16, 2008 at 10:24 am
Thanks to you both for you responses. It appears that both resolutions would require me to manually type in each name within the script to reformat them. Is...
October 16, 2008 at 10:01 am
No, two first names are not allowed. And I agree about how crazy it is with the entire full name in one column. I would love to change...
October 16, 2008 at 9:20 am
SELECT fullname
FROM users
Contents of fullname column
Col. A
Austin, Martin B
Brown, Steven A
Carter, Marvin E
Davis, Eric L
Francis, Mary G
Desired output is
Col. A ...
October 16, 2008 at 9:06 am
Worked like a charm! Thanks so much!
October 7, 2008 at 12:49 pm
Thanks for the response.
All I have so far is just a query that shows the two discussed columns plus a couple of others:
SELECT a.identificationnumber, a.facilitycode, b.OFFICE_LOCATION, a.deptname, a.fullname
FROM DATABASE_A.dbo.Users_...
September 11, 2008 at 9:19 am
Viewing 7 posts - 16 through 22 (of 22 total)