t.k Posted December 21, 2018 Posted December 21, 2018 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 ZZZZWHERE if length of $P{A} >= 10 then WHERE fieldA = substring( $P{A}, 10, (length of $P{A} - 10) ) else WHERE fieldA = $P{A} endif
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now