Re: getting error in sql

On 5/19/2015 2:52 PM, Hoteltravelfundotcom wrote:

hi Brigitta getting here error
SQL0104 - Token [ was not valid. Valid tokens: ( + - ? : DAY INF NAN RID
ROW RRN CASE CAST CHAR DATE DAYS HASH.

Two suggestions.
1) Read Chuck's reply. In particular, this: 'The next syntax error will
be for the '[' and ']' characters which are not supported as delimiters
[for anything AFaIK] in the SQL. If the column name is mixed-case, then
the proper delimiters are the '"' [i.e. the double-quote character].'

He tends to be very precise in his wording, which can sometimes result
in a long reply. I've been doing this for more than 30 years and I
assure you that I am definitely learning from his replies. Good stuff.
Do take the time to read it all.

2) You are looking at an SQL statement. None of us on this mail
reflector can see what you are looking at. Copy and paste the current
statement - the one you just tried - into your response so that we can
see what you see. Every time you try something else, paste the full
statement into your next question.