I assume you’re working with SQLite. The standard way to do this in a SQL query is to use double quotes around identifiers that might be misinterpreted (contains a space or other illegal character, using same name as a keyword, etc.). Of course, in Xojo, that means having to double-up the double quotes, like so:
db.SelectSQL("Select ""Part Number"" from Records..."
I don’t know if the same works for DatabaseRow.Column, I haven’t tried it:
row.Column("""Part Number""").StringValue
As Markus’ link shows, SQLite also supports square brackets [] or backticks ` to enclose identifiers. If those work through Xojo it would make it a little easier (not having to double-up the double quotes).