| /* |
| * Testcase Name : substr04.aql |
| * Description : Test substring2(string,position,position) built in function. |
| * Success : Yes |
| * Date : 18th April 2012 |
| */ |
| |
| write output to nc1:"rttest/string_substr04.adm"; |
| |
| for $a in [ substring2("hello world",7,11), |
| substring2("hello world",1,11), |
| substring2("hello world",3,7), |
| substring2("ABCD",3,6), |
| substring2("ABCD",0,4), |
| substring2("UC Irvine",4,string-length("UC Irvine")), |
| substring2("UC Irvine",0,string-length("UC Irvine")), |
| substring2("UC Irvine",1,string-length("UC Irvine")), |
| substring2(substring2("UC Irvine",4),0,string-length("Irvine")), |
| substring2(substring2("UC Irvine",4),0,(string-length("Irvine")/2)) |
| ] |
| return $a |