How can I parse two fields/columns to create a Composite/Primary Key in ASP.net - SQL?

[Ness]

Hello,
</o:p>
Can anyone tell me how to parse two fields/columns to create a Composite/Primary Key in SQL?
</o:p>
I want to take two characters from my first name column and four characters from my address column to create my Composite/Primary Key. For example: if first name is ?gene? and the address is ?<st1:City w:st="on"><st1:place w:st="on">Longview? my Composite/Primary Key would be ?gelong?. Any help would be greatly appreciated.
</o:p>
<st1:PersonName w:st="on">Gene Ness
geneness@msn.com

[Ness]

Hello,

This is no longer an open cry for help. I have solved my own problem. It was very simple. However, it took me some time inresearchingto find the answer.

Thanks to anyone who was trying to help me.

Gene Ness
geneness@msn.com