Can I use brackets to separate conditions in an SQL statement? (I am not in a position to test out this theory myself at the moment).
for example:
"SELECT * FROM Players WHERE (Surname BETWEEN 'A%' AND 'H%') AND PCode LIKE 'DE_ ___'"
I want to keep the between condition separate from the other parts of the sentence, if not possible then I'll have to live with it!
Thanks.
Adam
SQL newbie!
