Storing multiple values/range of values in a single cell

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PreethiGowri
    New Member
    • Oct 2012
    • 126

    Storing multiple values/range of values in a single cell

    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?
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    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.

    Comment

    • PreethiGowri
      New Member
      • Oct 2012
      • 126

      #3
      i shall work on that and get back to you, Thank you

      Comment

      Working...