Re: Break up a field into multiple rows

That was exactly it! Thanks!

Todd

"Tibor Karaszi" <tibor_not_pressed_ham_.karaszi_at_cornerstone.se> wrote in message news:<PSVv9.2238$1r1.66227_at_newsc.telia.net>...
> I assume that you don't use the query builder for this. There are so many
> constructs that the query builder doesn't support...
>
> Most probable reason is that the column where you have the LEFT and RIGHT
> expressions aren't given a name. And tables/views can't have columns with no
> name. Try:
>
> ,LEFT(territories, CHARINDEX(' ', territories)) AS yourcolname
> ,RIGHT(territories, CHARINDEX(' ', territories)) AS yourcolname
>
> (In SQL Server, the column name in a UNION is picked from the first query.
> In ANSI SQL it is, as I recall it, undefined in case of conflict; which is
> why I prefer to be consistent across the SELECTs in the UNION.)
> --
> Tibor Karaszi
Received on Thu Oct 31 2002 - 17:24:21 CET