Dear Richard,

In the work order seminar you encourage us leave some space after an SQL statement "just in case" or "just to make sure". I have heard you mention this in the Search form video 2 at 8:54 and in this (scheduling) video at 9:03.

Many times i have seen you demonstrate what could happen if a step is missed. For a learner like me, it alerts me stronger not to make such a mistake. In this instance, what could happen if no spaces are left after the SQL statement? I have tried this on my own with no visible problems. But i am sure there must be an experience you have gone through which would be good for us learners. Please share it if you can.

Thank you,

MICAH

---

Reply from Richard Rost:

Well, if you forget don't have a space, you could end up with something like this:

SELECT * FROM CustomerTWHERE CustomerID=3

This of course is an invalid SQL statement and will cause errors. That's why I always try to make sure I have spaces around everything because it's better to have TOO MANY spaces than to be missing a space.