RE: Result field Text in AS400 Query

["Paul Therrien" <paultherrien@xxxxxxxxxxxxxxxxxx>]

I beleive the OP is looking to put a label or column header on the field,
not change it to a text field.
On Mon, June 24, 2013 1:23 pm, Mike Cunningham wrote:
> Create a second field and use the DIGITS() expression.
>
> Field1 - expression 10 * 10 will be numeric
> Field2 - expression DIGITS(Field1) will be character
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vinay Gavankar
> Sent: Monday, June 24, 2013 2:18 PM
> To: Midrange Systems Technical Discussion
> Subject: Result field Text in AS400 Query
>
> Hi,
>
> Is there a way to define Text for a Result field created in AS400 Query.
> It defaults to the "Expression" when the field is added to a file created
> as an output of the Query, which is not very helpful.
>
> TIA
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.