C/ODBC - SQL syntax

PeterReid

Some of our fieldnames contain spaces and I was wondering what should be used to encapsulate these fields when building SQL for ASP pages (on IIS5)

The following SQL will work in Access but not in ASP'

SELECT * FROM Item WHERE [PartNo Alt] = 'XYZ1';

What do I need to change to make this work with ASP?

TIA

Pete

PrebenRasmussen

Use double quotes around the fieldnames:

SELECT * FROM Item WHERE "PartNo Alt" = 'XYZ1';

or

SELECT * FROM Item WHERE ""PartNo Alt"" = 'XYZ1';

depending on your situation.

PeterReid

Thanks!

The double quotes worked for me