TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mangesh barmate
NA
118
136.2k
How to use like operator in where condition ?
Oct 4 2012 4:24 AM
Hi,
I have following query which works properly...
select distinct als.sytem_no,
adm.firstName, + ' '+ adm.lastName as 'Name',
acs.*,als.*
from ac_storeKeys acs inner join ac_alarmSystems als
on acs.storeId=als.storeId
inner join ac_districts T
on acs.storeId='110'
inner join ac_districtManagers adm on adm.districts = T.district
--where acs.storeId='110'
where T.stores like '%110%'
But when i im changing where condition to where T.stores like '%0%'
It gives me all stores matches which having 0, here i only want to match 0 store id if it does.
Any apporach for this...
Reply
Answers (
1
)
Search for text in Database
Comparing Data in Two Consecutive Rows in SQL