var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Character based substring
I have a scenario as I need to fetch a part of word from the string based upon the symbol from the literal.
sentence : abde.fghi
from the above literal I need to fetch the characters after the .(dot) symbol.
here abde & fghi are dynamic.
can some one give me a query on this.
take a look at multiple functions together, such as substr, length and locate.
This is what I tried & its working
SELECT substr(COLUMN_NAME,locate('.',COLUMN_NAME)+1,lengt h(substr(COLUMN_NAME,locate('.',COLUMN_NAME)+1))) from SYSIBM.SYSDUMMY1;
Tags for this Thread