Text Delimiters



I am sure that lots of people must know the answer to this but I can't find
it anywhere.

If I want to insert a Firstname and Surname into an SQLCE table called
Clients I would use

INSERT INTO Clients (Firstname,Surname) VALUES('Fred','Bloggs')

but what happens if I want to insert Paddy O'Brian or Michael O'Connor

Because we are using an apostrophe in their names, this will cause the
Insert statement to fail

In Access I would use chr(34) to delimit the strings. Is there a way round
this in SQLSERVERCE?

--
With best wishes


Nigel Vandyk

Website:www.astarsoftware.co.uk


.



Relevant Pages

  • Re: The Unreal Championship 2 patch is out.
    ... Fixed team kills being counted for Weapon Master ... Fixed issue where if a player was standing on the enemy flag base and a teammate captured the flag to win the round, the flag would get into an invalid state ... Fixed a loading freeze that would happen sometimes under extremely bad network situations while joining a server ... Changed the order client connections are serviced to prevent clients with poor connections from being skipped due to network saturation, which aids lower bandwidth clients when the server is under stress ...
    (uk.games.video.xbox)
  • Re: The Unreal Championship 2 patch is out.
    ... Fixed team kills being counted for Weapon Master ... Fixed issue where if a player was standing on the enemy flag base and a teammate captured the flag to win the round, the flag would get into an invalid state ... Fixed a loading freeze that would happen sometimes under extremely bad network situations while joining a server ... Changed the order client connections are serviced to prevent clients with poor connections from being skipped due to network saturation, which aids lower bandwidth clients when the server is under stress ...
    (uk.games.video.xbox)
  • Re: The Unreal Championship 2 patch is out.
    ... Fixed team kills being counted for Weapon Master ... Fixed issue where if a player was standing on the enemy flag base and a teammate captured the flag to win the round, the flag would get into an invalid state ... Fixed a loading freeze that would happen sometimes under extremely bad network situations while joining a server ... Changed the order client connections are serviced to prevent clients with poor connections from being skipped due to network saturation, which aids lower bandwidth clients when the server is under stress ...
    (uk.games.video.xbox)
  • Re: How can I stop Outlook from turning UNC paths into links?
    ... clients will make clickable any URL schemed strings (http, https, ftp, ... Microsoft's Uniform Naming Convention (UNC) has been ... around for so long now that many e-mail clients will also make clickable ... composing in HTML format, not when composing in plain-text format. ...
    (microsoft.public.outlook.general)
  • Re: Rethink drop in centre
    ... co ordinator took me round to be introduced and it looks quite good. ... The other clients seemed to be quite friendly though rather like the ... patients who were on the medium/long stay wards when i was in hospital. ...
    (uk.people.support.depression)

Loading