Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    42

    Unanswered: concatenate words

    i have a block that contains the first,second and last name fields,and in another block i have a field called shortname,i need to fill it with the first,second and last name by keeping in mind the letter in this field should not exceed 15 character.

    thanks

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Concatenate those fields using SUBSTR function:
    :another_block.shortname := substr(:first_block.first ||' '|| :first_block.second ||' '|| :first_block.last, 1, 15);

Posting Permissions

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