Special characters

[Excel User]

Hi,

I have a field that contains special characters (', % etc) the ' causes
problems because it messes up the SQL insert/update command, what is the
best way to deal with this, I tried encode but then the entry in the DB is
not correct?

Thanks for any advice.

[Bob Barrows]

Use parameters. See:
http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e

Personally, I prefer using stored procedures, or saved parameter queries
as they are known in Access:

Access:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=e6lLVvOcDHA.1204%40TK2MSFTNGP12.phx.gbl

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=eHYxOyvaDHA.4020%40tk2msftngp13.phx.gbl

SQL Server:
http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/5d3c9d4409dc1701?hl=en

--
HTH,
Bob Barrows

[Sylvain Lafontaine]

You double them.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

"Excel User" <eu...@microsoft.com> wrote in message
news:%23uhqx0j...@TK2MSFTNGP06.phx.gbl...