Re: search comma separated db column

[Peter Brawley]

A string is a defined atomic type for which SELECT is designed to work. Likewise an int, a date, &c. Declaring a string column does not express the "same reasoning" as storing a comma-separated list of ints in a column.

If we are discussing a database, we are discussing how it is designed. If we are discussing how it is designed, we are discussing its defined types. Atomicity is a rule of database design (EF Codd wrote proofs, not heuristics). If our databases are to perform correctly, our users had better hope we had good reasons to break the rules of database design.

PB