Re: Insert a value in a SQL query result for a parameter list.

[Mike G.]

Sure:

Select field from table

union

select 'whatever text you want'

Mike G.

"Mike" <Mi...@discussions.microsoft.com> wrote in message
news:DC6C40D4-9B0E-41BD...@microsoft.com...
>I can create a parameter list box with values from a query from a database
> table. Note: The database table does not contain any spaces or Nulls.
> I am trying to find out if it's possible to have a value inserted into the
> results of the SQL query. This value could be a space or specific value.
> For example of the SQL resuts:
> Medium
> Low
> High
> Urgent
>
> I would like to insert a space into the above query results. Is this
> possible.
>
> Thanks.