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

Yes there is

substr(myvariable,1,10)

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

BOW

thanks Kristian K. Hansen
it worked

cheers