Is there a way to set the ANSI_NULLS and ANSI_WARNINGS options when using mssql_connect(), etc., to connect to an MS SQL server database? I'm trying to execute the following query via PHP: select R.Rank, CS.ACCOUNTNO, R.Path from openquery(Resumes, 'SELECT Rank, Path, FileName from SCOPE() where contains(contents, ''unix'') ' ) as R, CONTSUPP as CS WHERE (CS.Address1=R.Path and CS.RecType='L') order by R.Rank Desc Thanks muchly! ---- Gary Pullis Supporting: Sage MAS90/MAS200 | Linux | Windows NT | Novell Netware Office Management Technologies http://www.clwares.com