Dan writes "Just wondering if I could pick your brain on a particular SQL query I'm battling with..... :-)
I'm not too sure if it is going to be possible....
I have a table with a list of the courses that we offer and I am wanting to generate a query that will return all the Subject areas eg COMP, ACCT, ECON etc
In the 'subject' Table I have a column called 'subjectCode' which stores the Code for each subject eg COMP101, COMP204, ACCT101
I don't know if it is possible to query the table and get a table of just the Subject Areas, but if it only returned one COMP code(say COMP101) and one ACCT Code(say ACCT101) I could then use ASP.NET to use only the first 4 letters from the returned rows.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Very Difficult query!
Forum Locked
Posted - 01/08/2003 : 08:54:45
