Search results for query: *

How do I use DISTINCT (or whatever) to get DISTINCT Page_no? A page can be re-used in another course, and I only want to list pages in the chosen course.....now I get a row with the page from every course it is used in.... SELECT p.Page_No, p.OriginalCourse_No, p.Summary FROM...

I want to exclude a value, in this case list all students with lastname Andersson and where firstname is not Irene. SELECT name FROM student WHERE lastname='andersson' and firstname is not Irene??? What do I do?

hepp, I removed +1 and it was OK.....

eh, just one problem left..... the first letter in the old adress is left, so now the new adress is onew.se....

Hi, I am trying to update a part of an column containing emailadresses, and I got a tip using this: UPDATE Student SET EMail = SUBSTRING(EMail, 1, CHARINDEX('@', EMail) + 1) + [new.se] WHERE (EMail LIKE [%old.se]) But I get the error message Invalid column name 'new.se'...

I got a tip using this statement in order to update the domain adress in an emailadress, but I have problem with the function instr...... UPDATE Table SET Column = Left([Column], instr([Column],"@")) & "new.se" WHERE Column LIKE "*old.se"

I want to update the column emailadress but only the domainadress.. UPDATE Table SET Column LIKE '%new.se' WHERE Column LIKE '%old.se' but it seems to be impossible using wildcards in the SET-statement...