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
nishant ranjan
NA
390
0
splitting and storing in string to use in sql command
Nov 14 2011 7:24 AM
i have id and program_name
like 1 abc
2 xyz
3 pqr
on selection of programs i am storing data in database as ~1~3(if 1 and 3 is selected)
what i want to do now is that i want to write a query where program id not in(1,3)
since when i am retrieving data from database, i am getting data as ~1~3 and after splitting the data i am storing it in array but how can i use that with sql query with
not in
command
Reply
Answers (
2
)
XML
Silverlight Learn