> > > > SELECT * FROM table WHERE field IS NULL > > thats not the problem... :-). one example - i hope this makes > it clearer what i mean... > > SELECT ISNULL(ID,'') AS ID FROM $dbtableWith(nolock) WHERE > SUBSTRING(ID,7,6)=LEFT(?,6)
The only thing I can think of is to build your queries dynamically, based upon the connection. Use $dbh->get_info(17) to get the database name. ISNULL(ID, '') for SQL Server can be NVL(ID, '') (if I'm reading it right :)) Substring --> substr() (although you might have a 0 based vs. 1 based issue across multiple platforms). Nolock might be difficult across multiple platforms as some may not support it. Jeff
