Thanks.. But using osql is not an options... time to rethink the =
query... but I'm not sure that is possible.=20
[quoted text, click to view] "Arnie Rowland" <arnie@1568.com> wrote in message =
news:%23qoyAr7kGHA.1508@TK2MSFTNGP04.phx.gbl...
Not that I know of.=20
But you could use osql and output to a file.
--=20
Arnie Rowland, YACE*=20
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
[quoted text, click to view] "Garth" <Spam@Spam.ca> wrote in message =
news:OmDh7y4kGHA.4792@TK2MSFTNGP02.phx.gbl...
Thank Arnie, but I have yet another question is there a way to force =
QA into text mode via the query?
[quoted text, click to view] "Arnie Rowland" <arnie@1568.com> wrote in message =
news:eYVTvr2kGHA.4792@TK2MSFTNGP02.phx.gbl...
This may work -somewhat depends upon your output viewing tool.=20
USING Northwind
GO
SELECT=20
LastName
, char(13) + FirstName
, char(13) + City
, char(13) + PostalCode
FROM Employees
In Query Analyzer, this need 'Text' view -NOT 'Grid' view.
--=20
Arnie Rowland, YACE*=20
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
[quoted text, click to view] "Garth" <Spam@Spam.ca> wrote in message =
news:u93FVVukGHA.4816@TK2MSFTNGP05.phx.gbl...
> Is there a way within SQL to create a query with carriage =
returns within the=20
> output, so that the whole query is not all on one line?
>=20
>=20
>=20
> For example
>=20
> Instead of having "Make, Mode, Time , Date, etc."
>=20
>=20
>=20
> Return something like this:
>=20
> Make, Mode
>=20
> Time, Date
>=20
> Etc..
>=20
