Wildcars and userinput

Birger_Jacobsen_(danskadmin_-_(deleted))

How can I mix both user input and textKUAF.NAME = ' %1 ' GROUP BY KUAF.NAMEThanks

Bhupinder_Singh

What if you try these within your query:Oracle:KUAF.NAME = ' || %1 || '' MS-SQLKUAF.NAME = '' + %1 + ''Sincerely,Bhupinder-------------------------------------------------------------------------Bhupinder Singh, B.Math., B.Ed. Customer SupportOpen Text Corporation Waterloo, Ontario, CanadaCustomer support e-mail: support@opentext.comCustomer Support Telephone: 800-540-7292-------------------------------------------------------------------------