Query (test it first) update BB_BB60.COURSE_MAIN set AVAILABLE_IND='N' --On 20 July 2006 10:10 +0100 Jake Gannon <[log in to unmask]> wrote: > Hello > > you need to upadte AVAILABLE_IND in BB_BB60.COURSE_MAIN to N > > > > --On 20 July 2006 10:03 +0100 andrzej <[log in to unmask]> > wrote: > >> >> Hi to all in the world of Bb >> Does anyone have an SQL script that will make all courses unavailable. I >> am having a mental block!! >> >> Andrzej C. Marczewski BSc >> MLE Coordinator >> [log in to unmask] >> 01932 797714 >> >> > > > > Thanks > > ---------------------------- > Jake Gannon > [log in to unmask] > Computing Services > The University of Liverpool > External: 0151 794 4458 > Internal: 44458 > ---------------------------- Thanks ---------------------------- Jake Gannon [log in to unmask] Computing Services The University of Liverpool External: 0151 794 4458 Internal: 44458 ----------------------------