string-functions strr(ight)pos(ition)


  • strrpos(source, key)


The strrpos(source, key) function results in the character offset (position) of the first occurence of the key argument value in the source argument, starting from the end of the string value.

If no key value occurs as a substring in the source argument, the resulting value is null.

The strrpos function is case sensitive.


The domain-unit of both arguments must match or be void (literals or parameters can be combined with data items of any domain unit).


attribute<uint32> strrposA (ADomain) := strrpos(A, 't');
A strposA
‘Test’ 0
‘88hallo99’ null
’+)’ null
‘twee woorden’ 11
’ test met spatie’ 2

ADomain, nr of rows = 5

see also