Advertisement

05.22.2008 at 09:45AM PDT, ID: 23425062
[x]
Attachment Details

Trim characters in sql server 2000

Asked by savache27 in MS SQL Server, SQL Query Syntax

Tags:

Hi, I have a temporary table in sql server 2000. Sample data:

Course                              Email
20082.CIS.2010.01N      someemail@hotmail.com                  
20082.MATH.2030.01N  person2@hotmail.com

I was wondering if there is any way I can use query analyzer to remove the 20082 and the @hotmail.com  from each column. Any help would be greatly appreciated.           Start Free Trial
 
Keywords: Trim characters in sql server 2000
Title
1 trim character
2 Trim ?
3 T-SQL - Trim leading and trailing blan…
4 trim select
5 SQL Statement To Trim Characters
6 Trim leading characters
 
Loading Advertisement...
 
[+][-]05.22.2008 at 09:47AM PDT, ID: 21625506

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Query Syntax
Tags: sql
Sign Up Now!
Solution Provided By: aneeshattingal
Participating Experts: 3
Solution Grade: A
 
 
[+][-]05.22.2008 at 09:48AM PDT, ID: 21625514

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 09:51AM PDT, ID: 21625541

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 11:34AM PDT, ID: 21626364

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 11:36AM PDT, ID: 21626380

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 11:37AM PDT, ID: 21626390

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628