Many thanks for your help Howell also to Sean Lange, eveerything seems a bit simpler now and understandable.

I have to admit with some of my testing so far Sean's example work better however I both solutions do work. I like the built in System.Net.Mail.MailAddress functionality it makes things easier in some cases.

This has been my first succesful attempt in getting CLR to work so many thanks, now I need to improve on my C# so I can do more with CLR functions.

If you guys have any more working examples of CLR functions with C# on SQL server feel free to send them through.

Thanks.