nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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-%'