Jeffrey, Try using quotation marks: select * from REQ where "BUSINESS AREA" = '$var'
Keep in mind that using quotation marks means that the field name is now case sensitive. Regards, James OpenLink Software Inc. http://www.openlinksw.com On Fri, 10 May 2002 08:41:11 -0400, [EMAIL PROTECTED] (Jeffrey N Dyke) wrote: >Someone, in their infinite wisdom, named some, not all of course, tables >and columns with spaces, i.e. BUSINESS AREA in a SQL server database that i >am working with. You can run lots of queries that return fine, but when I >run a query such as "select * from REQ where BUSINESS AREA = '$var', i get >an error. Which, to me is completely understandable. I have tried using >the [BUSINESS AREA] notation, which will work on tables named with spaces, >but not field names. >I want to simply rename, and make the others adapt their code to conform. >But i wanted to try to solve this first. >Any ideas...? > >Thanks, >Jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php