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

Hello,
</o>
Can anyone tell me how to parse two fields/columns to create a Composite/Primary Key in SQL?
</o>
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"><st1lace w:st="on">Longview? my Composite/Primary Key would be ?gelong?. Any help would be greatly appreciated.
</o>
<st1ersonName w:st="on">Gene Ness
[email protected]

 

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
[email protected]