Improve company productivity with a Business Account.Sign Up

x
?
Solved

how to update a field with metacharacter inside the str?

Posted on 2004-10-20
4
Medium Priority
?
463 Views
Last Modified: 2012-08-13
like
update table set f1='some=\'asdfsadf\' ' where id=1;

but the above sql statement won't work,
i know i can update f1 correctly if i set some='asdfsadf' to a variable and use that variable in the sql statemet. but i want to know if i can set that in the sql statement..
0
Comment
Question by:smantha1979
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
izblank earned 200 total points
ID: 12365380
You just double the apostrophies that are part of the literal value:

update table set f1='some=''asdfsadf'' ' where id=1;
0
 
LVL 1

Expert Comment

by:giriky99
ID: 12366465

Hi ,You can use the  apostrophies like this...
 
create table temp1
([id] int,f1 varchar(30))

insert into temp1(Id,f1) values(1,'sum=''asdfsadf''')

select * from temp1

update temp1
set f1='sum=''asdfsadf''' where id=1

select * from temp1

if you any other problem..let me know..

0
 
LVL 1

Expert Comment

by:giriky99
ID: 12366470
You can use your string like this...with apostrophies

'some=\''asdfsadf\'''
0
 

Author Comment

by:smantha1979
ID: 12386987
i just found out that, can use char(39) too
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question