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 TouchToneTommy 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
Jul 15, 2003
171
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
web app not saving "all" records suddenly
Replies
3
Views
338
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
288
Livia8
Livia8
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
191
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
293
carp
carp
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
174
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top