2. More importantly, is there a basic rationale on when to use text, note, or varchar in various settings. Something like (I am making this up) text = editable/less than 250 characters, note = some editable/250-2000 characters, and varchar = not easily editable/over 2000 characters/pictures.
0 - 1500 chars TEXT 0 - 4092 Chars Note 0 - 256,000,000 Chars Varchar Pictures should be stored ad VarBIt not VarChar.. VarChar is editable and at present, all string manipulation routines are working against the datatype, so not easily editable no longer applies IMHO.
