You Guys are Awesome.
All the solutions work. But Mikes solution seems to me the most appropriate
in my scenario.
Regards,
SB
----- Original Message -----
From: "Mickael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 10:34 AM
Subject: Re: SQL Question
> Hi,
>
> I am not sure if you can add a column or not, but a simple way to do it if
you can add a column is create a column called TempCol or something
>
> Then
>
> Update TopStudents set tempcol = left(topstudents.studentdetails,
len(topstudents.studentdetails)-12) 12 being the number of charters after
the name
>
>
>
> Then your are left with just the names in tempcol
>
> then update the corrected name back to the original column
>
> update topstudents set studentdetails = topstudents.tempcol
>
> You can do this right in the query window in access, don't need CF
>
> Do it on a copy of the DB first.
> ----- Original Message -----
> From: Srimanta B
> To: CF-Talk
> Sent: Thursday, December 04, 2003 2:53 PM
> Subject: SQL Question
>
>
> Hello,
>
> Can someone please help me.
> I wish to delete part of a text in "student" field keeping part of the
text in the same field intact.
>
> Database: Access.
> Table name is: TopStudents
> The field names are: studentid, studentdetails, percentage, grade.
> The contents of the rows in the "studentdetails" field are similar to
this:
>
> Student Name1 - Year 1950
> Student Name2 - Year 1953
> Student Name3 - Year 1953
> Student Name4 - Year 1953
> Student Name5 - Year 1954
>
> I have about 500 rows of data in the table.
> What I wish to do is to keep the student names in the rows intact and
delete
> everything on the righthand side from the -.
>
> Any help would be much appreciated.
>
> Regards
> SB
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
