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!

check a viarable to see if it has a ' in it

Status
Not open for further replies.
HebieBug

HebieBug

Programmer
Jan 8, 2001
354
JP
Does anyone know of a way of checking to see if a variable contains a ' (apostrophe)?.
The user enters details into a text box and then it checks to see if the apostrophe is contained within that text box.
 
Sort by date Sort by votes
Use the Instr function. If it returns a value > 0 then the apostrophe exists

eg instr(1,"book","'",1) = 0
but instr(1,"boo'k","'",1) = 4 because it finds ' as the 4th char.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Question
Check if mobile number exists, with Api rest or other service. Possibile? 1
Replies
2
Views
295
sal21
sal21
sal21
  • Question
Strongm.... only for you - check if the customer have riceved the email 1
Replies
2
Views
266
sal21
sal21
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
506
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
354
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top