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]
