Truncating data

Results 1 to 2 of 2

Thread: Truncating data

  1. #1
    Join Date
    Dec 1969

    Default Truncating data

    How can I truncate data from an MS Acess 2000 database so it will be easier to view on a page. Say, take a 1000 character data entry from the DB and put only the first 50 characters in the cell of an HTML table?

  2. #2
    Join Date
    Dec 1969

    Default RE: Truncating data

    use <BR><BR>left(rs("c"),50)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts