In general, you don't want to store multiple values in a single cell...a relational database just isn't designed to handle data that way...there are string functions like charindex that can search through those fields, but the database engine is not optimized for that...a query that has to use one of those functions is going to take longer to return because it has to touch every record in the table. It might work all right with just a few records in the table, but it is going to start slowing down as more data is put in there.
On 2/6/06, Eric J. Hoffman <[EMAIL PROTECTED]> wrote: > Since the are only 3 possible values and one session variable, it shouldn't > be that big of a deal? Seemed like a lot more overhead setting up pivot > tables or something similar... > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54