Memo Fields in MSSQL

• Steve Riley

  Old Hand

  Points: 319

  More actions

  April 19, 2004 at 1:56 am

  #101964

  Hi All

  In Db3 files you can have a Memo field which just lets users add text and notes etc,

  what is the same filed in MSMSQL i need to have a sort of Memo field in my Database but not sure what one to use,

  I have at the moment used Text, if this the correct one,

  Also how to i read from a Memo Field in MSSQL into a Memo compoment not a DBMemo compoment.

  Thanks in Advance

  Steve

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  April 19, 2004 at 2:51 am

  #503275

  What is DB3?

  Take a look at the TEXT datatype in BOL.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]