Results 1 to 2 of 2

Thread: Jeff

  1. #1
    Jeff Turner Guest

    Default Jeff

    Hi, I am trying to get my results returned from a database to have a maximum length of about 250 characters, kind of like a preview... Is there any way to format the results so that only the first 250 characters are returned?

  2. #2
    Join Date
    Dec 1969

    Default RE: Jeff

    in your underlying SQL statement, add to the SELECT part:<BR>LEFT([fieldname],250)<BR><BR>or alternatively do the same with vbscript. the sql will probably be faster though.

Posting Permissions

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