substring — returns a substring of a string
substring
(
|
str string , |
| from integer , | |
sublen
integer
); |
Returns a substring of string str. The start index is 1 based. The substring is sublen characters long.
This function follows SQL 92.
substring('AbracadabrA',1,4) -> 'Abra'
substring('AbracadabrA',5,4) -> 'cada'
substring('AbracadabrA',8,4) -> 'abrA'
© OpenLink Software 2016 .
This HTML5 document contains 16 embedded RDF statements represented using HTML+Microdata notation.
The embedded RDF content will be recognized by any processor of HTML5 Microdata.
| Prefix | IRI |
|---|---|
| n2 | http://docs.openlinksw.com/virtuoso/fn_substring/ |
| schema | http://schema.org/ |
| n5 | http://creativecommons.org/licenses/by/4.0/ |
| rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| n4 | http://www.openlinksw.com/# |
| xsdh | http://www.w3.org/2001/XMLSchema# |
This HTML document contains 16 embedded RDF statements represented using (X)HTML+RDFa notation.
The embedded RDF content will be recognized by any processor of (X)HTML+RDFa.
| Prefix | URI |
|---|---|
| xmlns:n2 | http://docs.openlinksw.com/virtuoso/fn_substring/ |
| xmlns:schema | http://schema.org/ |
| xmlns:n5 | http://creativecommons.org/licenses/by/4.0/ |
| xmlns:rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| xmlns:n4 | http://www.openlinksw.com/# |
| xmlns:xsdh | http://www.w3.org/2001/XMLSchema# |
| Subject | Predicate | Object |
|---|---|---|
| n2: | rdf:type | schema:TechArticle |
| n2: | rdf:type | schema:APIReference |
| n2: | schema:name | substring |
| n2: | schema:copyrightHolder | _:vb80192 |
| n2: | schema:datePublished | 2016-09-09 16:16:54 |
| n2: | schema:headline | substring |
| n2: | schema:keywords | OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data,function,API,reference,substring |
| n2: | schema:license | n5:deed.en_US |
| n2: | schema:publisher | _:vb80191 |
| n2: | schema:url | n2: |
| _:vb80191 | rdf:type | schema:Organization |
| _:vb80191 | schema:name | OpenLink Software |
| _:vb80191 | schema:url | n4:this |
| _:vb80192 | rdf:type | schema:Organization |
| _:vb80192 | schema:name | OpenLink Software |
| _:vb80192 | schema:url | n4:this |