how to include an apostrophy inside a string

I am doing a row update in a table and the text contains a ' character, just
wondering how to do this?

for example
UPDATE table
SET field2 = 'text to enter to table's but does not work'
WHERE field1 = 133
the second apostrophy I want to not end the text section with.
Thanks.

--
Paul G
Software engineer.

YOu have to double quote that:

UPDATE table
SET field2 = 'text to enter to table''s but does not work'
WHERE field1 = 133


--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"Paul" wrote:

> I am doing a row update in a table and the text contains a ' character, ju
st
> wondering how to do this?
>
> for example
> UPDATE table
> SET field2 = 'text to enter to table's but does not work'
> WHERE field1 = 133
> the second apostrophy I want to not end the text section with.
> Thanks.
>
> --
> Paul G
> Software engineer.

ok thanks. One other question, when I use select from query analizer to
retreive a long text field and then copy and paste it to a word doc it looks
like it only returns the first portion of the large text string.  Also is
there anyway to view a large text field from query analyzer when you open th
e
table?  thanks again.
--
Paul G
Software engineer.


"Jens Süßmeyer" wrote:

> YOu have to double quote that:
>
> UPDATE table
> SET field2 = 'text to enter to table''s but does not work'
> WHERE field1 = 133
>
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Paul" wrote:
> 

QA is limited to a maximum  outpur of 8000 characters, if you don´t have ev
en
that you should look in Tools--> Options --> Results --> Maximum charcters
per column

to increase it to 8000
--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"Paul" wrote:

> ok thanks. One other question, when I use select from query analizer to
> retreive a long text field and then copy and paste it to a word doc it loo
ks
> like it only returns the first portion of the large text string.  Also is
> there anyway to view a large text field from query analyzer when you open 
the
> table?  thanks again.
> --
> Paul G
> Software engineer.
>
>
> "Jens Süßmeyer" wrote:
> 

ok thanks that should do it as it is way less than 8000 characters.
--
Paul G
Software engineer.


"Jens Süßmeyer" wrote:

> QA is limited to a maximum  outpur of 8000 characters, if you don´t have 
even
> that you should look in Tools--> Options --> Results --> Maximum charcters
> per column
>
> to increase it to 8000
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Paul" wrote:
> 

Just wondering if you know how to direct the results to a file?
--
Paul G
Software engineer.


"Jens Süßmeyer" wrote:

> QA is limited to a maximum  outpur of 8000 characters, if you don´t have 
even
> that you should look in Tools--> Options --> Results --> Maximum charcters
> per column
>
> to increase it to 8000
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Paul" wrote:
> 

Press CTRL-Shift+F in WA then Execute the query or select the menu Query -->
Results in File

or you use OSQL on the commandline with the -o <outputfile >switch
--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"Paul" wrote:

> Just wondering if you know how to direct the results to a file?
> --
> Paul G
> Software engineer.
>
>
> "Jens Süßmeyer" wrote:
> 

ok thanks this seems very useful.
--
Paul G
Software engineer.


"Jens Süßmeyer" wrote:

>
> Press CTRL-Shift+F in WA then Execute the query or select the menu Query -
->
> Results in File
>
> or you use OSQL on the commandline with the -o <outputfile >switch
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
> "Paul" wrote:
>