spaces in table and column names

[Anon]

Hi again,
I haven't been successful in finding info on dealing with spaces in table and column names. I'm involved in a project where I'm building web front-ends to data-sets in MS-SQL databases that haven't been constructed very well. Many of the tables contain spaces in the table names and spaces in the column names.

I'm mainly using queries that look like this:
<?php
Connection stuff here...
function build_eds_subject_matter_expertise() {
$query_string = "select Expertise,Employee Name,Email,ARS Team,Phone,AIM,Menu Test from EDS Subject Matter Expertise where Status = 0";
And the rest of the stuff here...
?>

Any help would be appreciated...hopefully I haven't overlooked a posting that already explains this.

Adam.

[smarlowe]

Try using quotes, like so:

$query = "select yada from \"table one\" where ...";

[Anon]

Thanks, I've tried escaping the quotes, using single-quotes instead of double-quotes, etc, and syntax errors are still generated. One thing that I thought I had tried was using the underscore (aka: single-character-wildcard). Coulda swore I've tried this before with no success, but it's working now and that's all that counts.

Thanks again...

[smarlowe]

Yeah, at work I've instituted a strict lower case, no spaces policy for things like file names and field names...

Of course, everything coming out of the mainframe is uppercase, but what can ya do?