Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    30

    Question Unanswered: How to design this feature (have 2 numbers in one field) ?

    I would like have a field in one of my tables can hold 2 different numbers same time (For example fld_people (1, 2) )

    Would you tell me how I can create a field like that? Format?

    Thank you!~

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    varchar

    would you tell me why you want a field like that?

    because storing two numbers into one column violates first normal form
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2003
    Posts
    30
    Quote Originally Posted by r937
    varchar

    would you tell me why you want a field like that?

    because storing two numbers into one column violates first normal form
    Thank you anyway. I have changed to a different way to perform this function.
    :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •