I have this query
SELECT *
FROM [RawData$]
WHERE 'Temperature[°C]' <= 100
But at the execution I get this error:
Data type mismatch in criteria expression.
The data in this column is 100% integer so I guess there is no problem.
Further this works fine:
SELECT *
FROM [RawData$]
WHERE 'Temperature[°C]'
I also tried this too but then I get no values at all:
SELECT *
FROM [RawData$]
WHERE 'Temperature[°C]' <= '100'
Actually the final question would be:
What query do i need to search a column which name is: Temperature[°C]
[Temperature[°C]]
[Temperature[[]°C]]
do not work.
This WHERE 'Temperature[°C]' <= 100
compares the literal string Temperature[°C]
to the Integer 100
.
Use WHERE [Temperature(°C)] < 100
instead.
Note:
[]
are reserved to be wrapped around fieldnames (much like you tried to use single quotes '
)()
.Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments