How can we help you today? How can we help you today?

incorrect syntax near keyword 'where'

When using the following where clause
WHERE Timestamp > '1/1/2008'

I receive the error "incorrect syntax near keyword 'where'"

does anybody know, is this due to the use of the keyword Timestamp as a column name? I have other where clauses working fine. I have also tried the following:
WHERE [Timestamp] > '1/1/2008'

This is a packaged app, so I don't have any control over the column names.

Any help here is greatly appreciated.

Thanks
jadams
0

Comments

1 comment

Sort by
  • richardjm
    Just omit the word WHERE from the where clause editor and it should be fine we automatically add the WHERE whenever there is anything set in the UI.

    HTH
    richardjm
    0

Add comment

Please sign in to leave a comment.