•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 425,926 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,704 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 4930 | Replies: 1
 |
| |
•
•
Join Date: Sep 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
about comparison operators, LIKE operator Can anybody ttell me the query for the question below, plz?
(a) Output the names of students and their addresses for those students who are living in Hunghom.
thx a lot~~~
(a) Output the names of students and their addresses for those students who are living in Hunghom.
thx a lot~~~
•
•
Join Date: Sep 2006
Posts: 90
Reputation:
Rep Power: 3
Solved Threads: 6
Junior Poster in Training
The details depend on how you've set up your table, but something like this:
Or if you need to pick Hunghorn from the address itself:
select name, address from MyTable where city = 'Hunghorn'
select name, address from MyTable where address like '%Hunghorn%'
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
- substitue of comparison operators (C++)
- Using binary operators! (C)
- accessing private data members (C++)
Other Threads in the MS SQL Forum
- Previous Thread: MS Access Charts
- Next Thread: MS SQL Joins - newb assistance
