I don't believe Miko was being negative, more he was pointing out the pitfalls of the OP's solution. Thats not negativity, just an informed response! =]

Also, SubStr is ASP/VBScript syntax with .NET you would use: someString.SubString(<start index>, <length>);

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

Hi! Thank you all for the replies! Erm, actually because this table isn't exactly a table, because queries have been done to it. If there is a PK, then it most probably is the email.
I used substring in the end, bcoz it worked better for me, then spilt. I don't know how come I keep getting errors at spilt.
Thank you so much for all of your help! Really saved & helped me out!