How do I get the first character in gsv?

[johanco123]

Hi Bruce

How can I get the first character of a value in a field

say the value is 'Payment' and I just want the 'P'
like in windows it work as   sp:description[1]

I want the same result in p_web.gsv('sp:description') to display the 'P'

Kind regards
Johan

[johanco123]

I use the following

sub(p_web.gsv('sp:description'),1,1))

tanks

[JohanR]

Hi Johan

Try to move the session var to a local var first and then slice it

Johan

[Bruce]

>> Try to move the session var to a local var first and then slice it

why? sub works just fine.

Cheers
Bruce