On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
You can set it as an alias using AS .
Respectfully,
Ligaya Turmelle
"James E Hicks III" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Isn't there a way to prefix (or postfix) a tables column names in the
results
> of a select. For example I have a table named from_address. This t
Isn't there a way to prefix (or postfix) a tables column names in the results
of a select. For example I have a table named from_address. This table has
the column names line1,line2,line3,line4,line5. When I do a select query on
from_address I want all columns to return as from_line1, from_line2
