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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I strip Apostrophe from DATA

Status
Not open for further replies.
bmann

bmann

Programmer
Oct 8, 2002
128
US
How do I strip Apostrophe from DATA.

Example:

O'NEIL

I appreciate your help.
 
Sort by date Sort by votes
strName = Replace(strName , "'", "")

"Have a great day today and a better day tomorrow!
 
Upvote 0 Downvote
Hi
Maybe
MyStr="O'Neill"
Replace(MyStr,"'","")
 
Upvote 0 Downvote
If the problem is having single quotes in SQL's string literal:
strSQL = strSQL & "WHERE somefield=[tt]'"[/tt] & Replace(somevar, [tt]"'", "''"[/tt]) & [tt]"'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
518
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
2K
lameid
lameid
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
463
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
1K
combo
combo
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top