Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  how can i do that

Author  Topic  webstep Starting Member 3 Posts Posted - 2001-07-07 : 19:43:37 Hi Room I am trying to write Query to extract the left part of an email I have some emails that look like this test <my_Account@mydomain> xxxx <me_athome_@mydomain> How can I remove the string before the < sign then insert the result into another column within the same table so the result I would have is the email address in one column and the name in another with out the <> signs Edited by - webstep on 07/08/2001 05:18:57