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!

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

search database for special word

Status
Not open for further replies.

TonyVBnet

Programmer
Mar 31, 2004
17
DE
hi.
i've got some questions about databases.
the program i'm developing should search database-fields for a special string. i think with something like SELECT * FROM table WHERE field LIKE 'http%' it shouldn't be a prob. my question: is it possible, to return a value? i want to store the found strings in a database. do you have any idea, how i could do it?
another question: i want to store a string with apostrophs in a database. is it in some way possible to delete them? it looks like 'word'. so the apostrophs aren't necessary.
thx for you help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top