Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with single quote

Status
Not open for further replies.
daka94

daka94

Programmer
Apr 27, 2001
33
US
hai,
when i am sending any text which contains single quotes in to the field type text.it is giving error.what type of data type i has to take when i am passing text which contains single quotes.
please help me
thank u
 
Sort by date Sort by votes

Do you refer to embedded quotes such as in the word can't in the following sentence?

'I can't make this sentence work in SQL Server. Help!'

Replace the embedded single quote with two single quotes.

'I can''t make this sentence work in SQL Server. Help!'

That will work in SQL Server. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
511
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
586
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
955
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
564
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
487
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top