Re: a newbie question

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

It's not recommended, but you can use just about any special character in
your field or table names simply by enclosing the name in square brackets
(by default...depending on your database settings, you may have to use
double-quotes instead of square brackets).


Rob

"WebRaster" <webmaster@xxxxxxxxx> wrote in message
news:dh98v3$amd$1@xxxxxxxxxxxxxxxxxxxxxxx
> Can I use the character ":" in a field name of a database SQL? For example
> can I name a field as TitlePerson:D1 ?
>
> Thanks
>


.

Relevant Pages

  • Re: a newbie question
    ... but you can use just about any special character in ... > your field or table names simply by enclosing the name in square brackets ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Locating the string "#" in a field
    ... Enclose the special character in square brackets - ie: ... instances of the string "#" within a text field. ...
    (microsoft.public.access.queries)
  • Re: Connecting to a second instance of SQL
    ... There are no invalid characters. ... Try enclosing the instance name in square brackets, e.g., ... Arnie Rowland, Ph.D. ...
    (microsoft.public.sqlserver.connect)
  • 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: Nothing Generates for OleDbCommandBuilder
    ... the CommandBuilder to resolve this, possibly by enclosing the fields ... in square brackets. ...
    (microsoft.public.dotnet.languages.vb)