Query selection criteria - changing description field..?

The system always asks with the description of the field you refer to with the parameter variable in the select statement.

I sometimes defined a UDT only for getting the appropriate title in the parameter entering window. The table has no data; I used it only for its field names.

(The parameter request can be placed inside a comment and the entered value is used setting an SQL variable like this:

declare @d datetime
/*select t.createdate from ordr t where t.createdate=[%0]*/
set @d=[%0]

This SQL variable can be used later in the real query.)

(But then you loose the possibility to choose from the u2018List of existing valuesu2019

have you tried use something like this ...: select Field as "name you want" ... from OWOR

Maybe using an alias for every field can solve this ...

Well let us now if this help to you.

regards,