Hi Richard, just 2 quick questions: 1)For the LIKE keyword, why would you not put '' around the [FirstLetter] Parameter piece, when you concatenate it with '*'? 2)Why does the * and # symbols from Access use the same symbol (!) in other SQL servers? Thank you very much for your help.
Reply from Alex Hedley:
1) Do you have the full string he uses? It's been a while since I've watched this one
2) In what context. Access uses # for dates, * for select all Fields You use * in T-SQL
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Seminar Part 1.
