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

using like clause with ampersand "&"

Status
Not open for further replies.
rk68

rk68

Programmer
Joined
Jul 15, 2003
Messages
172
Location
IN
Hi,

I have data with has "&" in the text.
How can I extract the data using "LIKE" clause with ampersand?

TIA,
RAJ
 
Sort by date Sort by votes

[tt]... WHERE SomeField LIKE [blue]'%&%'[/blue][/tt]

Have fun.

---- Andy

There is a great need for a sarcasm font.
 
Upvote 0 Downvote
if you are running in sqlplus, make very sure your issue the 'SET DEFINE OFF" command or it will assume that the "&" is a replacement string

Bill
Lead Application Developer
New York State, USA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

George L
  • Locked
  • Question Question
web app not saving "all" records suddenly
Replies
3
Views
1K
carp
carp
Livia8
  • Locked
  • Question Question
Alternative to "locate" command
Replies
0
Views
1K
Livia8
Livia8
Livia8
  • Locked
  • Question Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC
Replies
5
Views
782
Livia8
Livia8
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
Livia8
  • Locked
  • Question Question
Generate report/output on the basis of "enquiry" responsibilities only
Replies
16
Views
1K
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top