pretty decent keywork search.
I've seen good stuff on their site dealing with these type of issues. I'd
dig around and give specific data but have to go to a late meeting-
-----Original Message-----
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 4:45 PM
To: CF-Talk
Subject: RE: SQL Question
Looking at this as it comes back to me I realized this will only work if all
the students in your table graduated in the 11th century or later. Watch out
for that one ;)
Adam.
-----Original Message-----
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 3:08 PM
To: CF-Talk
Subject: RE: SQL Question
UPDATE TopStudents
SET studentdetails = left(studentdetails, length(studentdetails) - 12)
WHERE 0 = 0
change the left and length functions according to your DB semantics.
-----Original Message-----
From: Srimanta B [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 1:54 PM
To: CF-Talk
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]
