Remi - for once I have to disagree with you (:-(

I know HEAPS of people who have been developing databases for YEARS - who don't even follow the very basics...

Since you installed the database you must have access to the server - you should first query the database directly - using either of the sql tools - enterprise manager...

Do you mean that you can expand on any of the folders - "tables", "procedures" etc.. and see all the user created database objects but cannot query them ?!

Are you...

This from an article on compatibility: with "SET ANSI_DEFAULTS ON" SQL Server adheres to the behavior that is compatible with ANSI standards

Are you trying to get the resigned date for one particular person - or are you trying to get the names of all people who resigned on a particular date...

Until someone comes up with something smarter...an union should work in the interim...

select * from table where attended = 'absent' and student_id = @id and date = @date

union

select * from...

Can't you just provide these "spoiled end-users" with customized views ?!?! Why spoil them any more than they already are ?!

ps:prefer strawberries and cream myself!

Don't have time to go through whole script but you may want to try:

SET @DateRange = '03/05/2005','04/05/2005','05/05/2005' etc.....

Usually if an UPDATE statement does not throw any errors AND doesn't do any updates either the first thing to do is to find out if you get results from...

Is your text column of text datatype ?! Here's some info from BOL that may help:

The current TEXTSIZE setting is reported by the @@TEXTSIZE function and is changed with the...

You can look at tables and views through the object browser in QA - do you want to do more ?!

& this from MS website related to underscore....maybe you just need to upgrade your MDAC version ....worth a shot...

"Calling the ODBC API SQLTables() function on a SQL Server database name...

I know that this is with a LIKE expression but I thought it was interesting (came across this in one of my Googles and have lost the site url) and...

I cannot test this as I don't have it implemented on my machine but here're a few suggestions after going through BOL...let me know if any of them do the...

"dig away under the hood all you want".....

dig - dig - dig......will get back to y'all when I reach China!