Skip to Content
0
Former Member
Feb 18, 2009 at 01:18 AM

Modify parameter title in qoery

31 Views

Dear experts,

I wrote a query as follow,

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0 WHERE T0.[ItemCode] like '[%0]%'

When I run it, it will show a parameter and the title is Item No. Could I modify it ? How to do that?

I know I can create an UDF and define the title, but if I do that I cann't use the function of list of existing value.

Glen