By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

About where clause

Parul Bagadia
P: 188
Hello ppl, m new in SQL programing, in one of the assignments; we have to select guest_name from the guests table who all stay in PUNE, but the thing is m taking complete address of that person; and in that address somewhere city will be mentioned.
So is it possible in SQL that attribute will get selected just because of one word from the complete address?
Sep 15 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,017
You can try this:

Expand|Select|Wrap|Line Numbers
  1. address like '%city%'
Good luck.
Sep 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.