Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26

    Unanswered: Truncating a input

    Hi all,
    I want to insert a value which is 15 charcter in length to a variable which is only 10 charcter in length.

    eg: name Character(10) = 'abcdefghijklmn'.

    I just want only the first 10 letters to be inserted in to name. is there any truncate function. please let me know.

    cheers
    melb

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow

    Yes there is

    substr(myvariable,1,10)

    but please see the sql reference, or the topmost
    posts in this forum

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26
    thanks Kristian K. Hansen
    it worked

    cheers

Posting Permissions

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