Re: Prefixing Column Names in Select

2004-02-19 Thread James E Hicks III
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

Re: Prefixing Column Names in Select

2004-02-19 Thread James E Hicks III
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

Re: Prefixing Column Names in Select

2004-02-18 Thread Ligaya Turmelle
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