*
* This library is free software; you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation; either version 2.1 of the License, or
* (at your option) any later version.
*
* This library is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public
* License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301,
* USA.
*
* [Java is a trademark or registered trademark of Sun Microsystems, Inc.
* in the United States and other countries.]
*
* ---------------
* ExpressionFunctionLocate.java
* ---------------
* Author: Volker Berlin
*
* Created on 20.06.2004
*/
package smallsql.database;
public class ExpressionFunctionLocate extends ExpressionFunctionReturnInt {
int getFunction() {
return SQLTokenizer.LOCATE;
}
boolean isNull() throws Exception {
return param1.isNull() || param2.isNull();
}
int getInt() throws Exception {
String suchstr = param1.getString();
String value = param2.getString();
if(suchstr == null || value == null || suchstr.length() == 0 || value.length() == 0) return 0;
int start = 0;
if(param3 != null){
start = param3.getInt()-1;
}
return value.toUpperCase().indexOf( suchstr.toUpperCase(), start ) +1;
}
}