> ISNULL(ID, '') for SQL Server can be NVL(ID, '') (if I'm reading it > right :)) a good tip. i have searched about... and found Oracle uses NVL(), MySQL uses IFNULL() and MsSQL uses ISNULL... i ask myself why DBI will not give use a global useable function :-(((.
> Nolock might be difficult across multiple platforms as some may not > support it. yes. it will not work in MySQL for e.g. but this is very bad... nolock is realy needed on high volume sites... and ISNULL() is needed for every varchar field. no real good ways to workaround :-(. by the way... the software will be platform specific in future. Alex
