Hi Alf You'd be better off asking this type of question in the database list. I'm not familiar with MS-SQL, the syntax doesn't look much different to the MySQL flavour. When you say " whether the query works or not" do you mean the query is failing with an error, or it simply returns no data? I'd suggest you test for TRUE first to determine if the query suceeded, but returned no data. If that fails, test for FALSE. Niel -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
