|
-
May 30th, 2000, 11:14 PM
#1
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!
-
May 31st, 2000, 12:10 AM
#2
"It's cold gin time again ..."
Check out my website here.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|