Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 urgent! want to update a cell with some ' inside !

Author  Topic 

fabianus76
Posting Yak Master

191 Posts

Posted - 2005-10-05 : 18:39:03
How do I have to format the following query so that the ' is not disturbing?

UPDATE mytable SET myColumn = "that's what should be in the cell"

You see what I mean? the ' in that's is the problem :-(

Thank you for any help!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-05 : 18:41:03
UPDATE mytable SET myColumn = 'that''s what should be in the cell'

Tara
Go to Top of Page

fabianus76
Posting Yak Master

191 Posts

Posted - 2005-10-05 : 18:49:30
Hi Tara,

thank you for this quick reply - that helps me in an urgent situatio.

Thanks again,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !
Go to Top of Page
   

- Advertisement -