Search using LIKE doesn't work

[koko]

I'm trying to build a simple application where a user can type a partial drug name into a single line edit control, and the entire drug name and code number will come up in a datawindow. However, it's not working. Here's my datawindow SELECT statement:<br>
<br>
SELECT

 

[rossman]

Sorry I couldn't read the select statement. But I think you may get away with the % which is a Oracle wildcard. Just guessing

 

[BenClark]

Just place the % sign in from of the partial drug name and use LIKE in the where clause.<br>
<br>
WHERE drugname LIKE &quot;partial%&quot;<br>
OR<br>
WHERE drugname LIKE &quot;%partial%&quot;<br>
OR<br>
WHERE drugname LIKE &quot;%partial&quot;<br>
<br>