--=__PartA980FA53.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Is there another way to quote a field alias (containing spaces) than with
=
double quotes?
=20
This works:
SELECT actions.addresstypes.addresstype AS "Address Type" FROM
actions.addr=
esstypes
=20
I would like something like this
SELECT actions.addresstypes.addresstype AS [Address Type] FROM
actions.addr=
esstypes
=20
Is that possible?
Thanks for any ideas.
--=__PartA980FA53.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Is there another way to quote a field alias (containing spaces)
=
than with double quotes?</DIV>
<DIV> </DIV>
<DIV>This works:</DIV>
<DIV>SELECT actions.addresstypes.addresstype AS "Address Type" FROM =
actions.addresstypes</DIV>
<DIV> </DIV>
<DIV>I would like something like this</DIV>
<DIV>
<DIV>SELECT actions.addresstypes.addresstype AS [Address Type] FROM =
actions.addresstypes</DIV>
<DIV> </DIV>
<DIV>Is that possible?</DIV>
<DIV>Thanks for any ideas.</DIV></DIV></BODY></HTML>
--=__PartA980FA53.0__=--