How to create a text input control based on partial text or number for filtering a report

What version of BusinessObjects are you using? Can you provide some free-hand SQL with sample data?

Noel