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

Storing multiple values/range of values in a single cell

100+
P: 126
Can we store multiple values or range of values in a single cell, something like 1111-1115 i.e a single cell in the table should store the values 1111,1112,1113,1114,1115?
If yes, then how do we do it? and what is the query for that?
Apr 4 '13 #1
Share this Question
Share on Google+
2 Replies


10K+
P: 13,264
You can store them in a varchar column but you should not be storing them like that. Rather have two columns (start and end) to store the end points.
Apr 4 '13 #2

100+
P: 126
i shall work on that and get back to you, Thank you
Apr 4 '13 #3

Post your reply

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