> It might be faster, but it is direct SQL and may not work on any database...
> > select count(*) from HPD_Help_Desk Does Remedy support a database where the above ANSI SQL won't work? I suppose if ARS implements view names for their tables differently in another database, it would not be "HPD_Help_Desk", but does anyone know of which database that would be? Just curious because the above works on Oracle and SQL Server. Dale Hurtt _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
