-
I've got a select and I want to delete the last 5 characters.
Can I do it with subst.My example is:
v_select:='select .....'
substr(v_select,1,3)
But if I don't know that the final character is in 3rd position,how can I do it without counting all the characters...
Thanks
-
The easiest way is counting all the characters:
substr(v_select, 1, length(v_select)-5)
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|