Thread: A little restructuring needed?
View Single Post
  #2 (permalink)  
Old 11-29-08, 09:32
r937 r937 is offline
SQL Consultant
  
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,083
start by redesigning your tables so that you never store a comma-separated list of values inside a single column

do a search for first normal form

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote