How to use Parameter's Length and substring for parameter's length in SQL query? I want to swith WHERE clause by length of parameter. like this; SELECT XXX FROM ZZZZ WHERE if length of $P{A} >= 10 then WHERE fieldA = substring( $P{A}, 10, (length of $P{A} - 10) ) else WHERE fieldA = $P{A} endif