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

sunnyside · #1 (**permalink**) 10-20-04, 13:23

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!~

r937 · #2 (**permalink**) 10-20-04, 19:56

varchar

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

because storing two numbers into one column violates first normal form

sunnyside · #3 (**permalink**) 10-21-04, 00:11

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.
:-)

Internet Services

Web Development

Digital Marketing

Consumer Tech