Jae
11-13-2000, 09:29 PM
I have tough time to understand the SQL syntax
especially, "How SQL treats white spaces -- space, tab, enter key."
In the following simple SQL command,
select *
from empinfo
where FirstName = 'John';
I found the following observations.
1. We must need a space right after * symbol otherwise
It won't be parsed.
2. Operator (=, *, + ,.. ) can ignore spaces when they are part
of statements.
Question.
I am not still clear about how SQL parser treats white spaces.
Thank you a lot
Jae
especially, "How SQL treats white spaces -- space, tab, enter key."
In the following simple SQL command,
select *
from empinfo
where FirstName = 'John';
I found the following observations.
1. We must need a space right after * symbol otherwise
It won't be parsed.
2. Operator (=, *, + ,.. ) can ignore spaces when they are part
of statements.
Question.
I am not still clear about how SQL parser treats white spaces.
Thank you a lot
Jae