"amit" <amit.mural***@gmail.com> wrote in message
news:1159957895.583596.216140@i3g2000cwc.googlegroups.com...
> Hi guys I am trying to use select Query with Like operator
>
> Select DrugName from Stock where (DrugName LIKE '*s*')
>
> This query works in MS-Access Query option and returns some records,
> but when I run it through VB .net programm it dosen't return any result
> nither it gives any error.
>
> What could be the problem plz. help
>

> Hi guys I am trying to use select Query with Like operator
>
> Select DrugName from Stock where (DrugName LIKE '*s*')
>
> This query works in MS-Access Query option and returns some records,
> but when I run it through VB .net programm it dosen't return any result
> nither it gives any error.
>
> What could be the problem plz. help
>

> On 4 Oct 2006 04:43:58 -0700, "amit" <amit.mural***@gmail.com> wrote:
>
> ¤ Hello
> ¤
> ¤ Thanks for the reply
> ¤
> ¤ I tried using '%s%' instade of '*s*'
> ¤
> ¤ There are two records starting with 's' but is returns only one.
>
> I would double-check your results. I'm not sure how you are displaying the data in order to verify
> that only one instance is being returned, but there is no reason it would work for one row and not
> another.
>
> Also, I would remove the parentheses around your WHERE statement. They are unnecessary.
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)