|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Adding "like" to a prompt in SQL oracle
I'm trying to create a query for a CD collection. I need a prompt that will search for any part of a song title in either lower or upper case, but I'm having problems. I know how to do a prompt and know how to search for part of a string, but can't seem to put the 2 together. Here's my query (that's not working):
SQL> select l.labelname, c.catnum, a.artistfirst, a.artistlast, c.title, s.songtitle 2 from cdlabel l, cdcatelog c, artist a, song s 3 where l.labelcode = c.labelcode 4 and c.catnum = s.catnum 5 and a.artistnum = c.artistnum 6 and lower(s.songtitle) like '&%EnterTitle%' 7 ; I have tried every which way for the syntax on line 6 to work to no avail. What am I doing wrong? Thanking you in advance, Cheryl |
|
#2
|
|||
|
|||
|
I figured it out. Last line should read:
and lower(s.songtitle) like '%&Entertitle%' I was sure I had tried it that way earlier, but I guess not. *sigh* |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Adding "like" to a prompt in SQL oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|