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

prepare sql string

Status
Not open for further replies.
j420exe

j420exe

MIS
Feb 17, 2002
28
US
The string that I am passing into a function to build a sql statement is "b's"

How can I search the string and find the single tick(s) and then once I find the single tick I can add another single tick to it so the sql statement will not error out when querying an access database?

Thanks in advance!
 
Sort by date Sort by votes
Solved my own problem. Imagine that.

PrepareSQLString =
Replace$(Trim$(Replace$(s, Chr$(0), " ")), "'", "''")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Update SQL's varbinary(max) field from VB6
Replies
4
Views
387
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
631
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to use a combo box to get data from SQL? 1
Replies
1
Views
273
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to get data from sql into a combo box in vb6?
Replies
3
Views
426
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
Write a fixed string 1
Replies
9
Views
448
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top