Join 2 fields to get initials HELP

Question

Join 2 fields to get initials HELP

ritesh-385882

Mr or Mrs. 500

Points: 533
More actions
November 19, 2007 at 7:18 am

#71004

Hi , Im trying to get a new column called initial .. I want to obtain this data from the two columns First name and surname.
eg. Bob Ryder I want to get the first letter from both field and put in the Initials. eg- it should now say BR in initials..
HELP
Regards
Ritesh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

ritesh (11/19/2007)
Hi , Im trying to get a new column called initial .. I want to obtain this data from the two columns First name and surname.
eg. Bob Ryder I want to get the first letter from both field and put in the Initials. eg- it should now say BR in initials..
HELP
Regards
Ritesh

select left([First name],1)+left(surname,1) from names

assuming that the table is called names, and the two columns in question are [First name], surname, and that these are not null

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 2

You could also make the (left([First name],1)+left(surname,1)) expression a computed column.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

ritesh-385882 Mr or Mrs. 500 Points: 533 More actions · Answer 3

ritesh-385882

Mr or Mrs. 500

Points: 533

November 19, 2007 at 7:37 am

#752281

Thanks very much -you saved me once again

Regards

Alex Cooper SSC-Addicted Points: 499 More actions · Answer 4

I would try this:

(left([First name],1)+left(surname,1))

to computer you initial column.

Hope this helps

Coops

Keith Hoffman SSC Rookie Points: 28 More actions · Answer 5

or...

upper(coalesce(left([First name],1),'')) + upper(coalesce(left(surname,1),''))

...when you factor in Murphy's Law