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 derfloh 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
Joined
Oct 8, 2002
Messages
128
Location
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

mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
595
mhshane
mhshane
combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
865
mikrom
mikrom
serino
  • Locked
  • Question Question
Delete From Table
Replies
1
Views
934
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
261
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top