Re: Access Database Field called E

Tech-Archive recommends: Fix windows errors by optimizing your registry

> Am I right in thinking I cannot use the letter E as a field name?

Any SQL reserved words can be used by using square brackets

So

SELECT [Desc] FROM [Break]

Stephen Howe


.

Relevant Pages

  • Re: Building SQL query when table is two words...
    ... You use Square Brackets and you think this is Truth. ... SELECT * FROM `All Students` ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: casting Object to byte array
    ... > The problem was I was not adding the square brackets in my casting and was ... Jon Skeet - ... If replying to the group, please do not mail me too ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Fatal error: Function name must be a string
    ... but in PHP we use square brackets for ... array indices, thus: ... Steve ... Prev by Date: ...
    (alt.php)
  • Re: Culverins
    ... Entro, as was listed in square brackets in the subject header. ... Prev by Date: ...
    (rec.games.roguelike.angband)
  • Re: Delphi Conversion of "C" enum
    ... Sets are defined by square brackets enclosing enumerated values. ... Alan Lloyd ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)