incorrect syntax near keyword 'where'
jadams
Posts: 2
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
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
Comments
HTH
Project Manager
Red Gate Software Ltd