Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

SQL Parameters

edited August 2014 in End User
Hi

We want to use an Advantage Full Text Search in the SQL selection of a
report, i.e.

select * from contract
WHERE CONTAINS( *, '*BAKE*' )

When written like this in SQL the Search works exactly as expected.

Is there anyway I can pass the *BAKE* as a user parameter to the
report? rather than it being hard coded into the SQL?

Many Thanks

Philip L Jackson

Comments

This discussion has been closed.