ThingWorx SQL Query

[PSB]

Hi all,

I have to run a query on MS SQL Database table, which has columns with spaces in their names (ex: 'SA03 LH CS BRG DEPTH (mm)').

How do I query this successfully?

Here is an example query:

SELECT *

FROM <<tableName>>

WHERE <<tagName>> != 0;

Here <<tagName>> is a column with space in its name.

[Arun_C]

Hi @PSB ,

I have tried with PostgreSQL Query. It is working for me.

SELECT * FROM public.accounts where "SA03 LH CS BRG DEPTH (mm)" = 1

Thanks & Regards,

Arun C

[PSB]

Hi @Arun_C ,

PFA screenshot, I have tried it on MS SQL it doesn't seem to be working.

Can you try it on MS SQL & let me know.

[Arun_C · Accepted solution]

Hi @PSB ,

I have tried in MS SQL DB. Kindly find the below atttached snapshot for your references.

Thanks & Regards,

Arun C