Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
question about SQL LIKE clause
Ronald__Jayne_-_Disabled_15-Jul-05_(x-afmcuser1_-_
trying to generate a Live Report that displays all archived workflows that begin with user-specified strings ... is there a way to have a parameter substitution in the LIKE clause ? e.g., given that the user has entered values at the prompts for parameter 1 and parameter 2 something like ... (?) SELECT * from ArchivedWork WHERE subwork_title LIKE '&1-&2-XYZ-%%'
Find more posts tagged with
Comments
jamespate
e.g. %1||'-'||%2||'-XYZ-%'