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

character search

Status
Not open for further replies.
sp1502

sp1502

Programmer
Dec 15, 2000
15
US
is there any way in sql to search for a particular sequence of characters in a field regardless of position. For
example the word "PAY" in field "OTPAY1234".

Thanks in advance.
 
Sort by date Sort by votes
select col_name from your table
where col_name like '%PAY%'
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

xwb
  • Locked
  • Question
One level recursive search 1
Replies
2
Views
89
xwb
xwb
fredsnertz
  • Locked
  • Question
Multi table search
Replies
3
Views
48
r937
r937
radicalrod
  • Locked
  • Question
Multi Table partial text search
Replies
1
Views
31
JarlH
JarlH
leburg
  • Locked
  • Question
search all tables
Replies
2
Views
25
cjashwell
cjashwell
charmanraye
  • Locked
  • Question
SQL Search Results Problem
Replies
2
Views
28
charmanraye
charmanraye

Part and Inventory Search

Sponsor

Back
Top