Last post Sep 01, 2008 05:55 AM by hans_v
Sep 01, 2008 03:08 AM|Nitin Bansal|LINK
Hi to All,
I am using vb.net with access.
I am unable to retrieve data with Like Operator, my query is -
Select ID, Comments From Stock Where Comments Like 'sum*'
But i am getting blank Result.
Can Anybody help me about this ?
Thanks in Adv...........
Sep 01, 2008 03:55 AM|suthish nair|LINK
Try out this, I never tried MsAccess as DB.
Select ID, Comments From Stock Where Comments Like "sum*"
Select ID, Comments From Stock Where lower(Comments) Like "sum*"
Sep 01, 2008 05:54 AM|blueberri|LINK
Hi Nitin Bansal
Could you please show your query string here so that we can take a look at the coding clearly and solve the problem together :)
Sep 01, 2008 05:55 AM|hans_v|LINK
In ADO.NET you should use % instead of *
Select ID, Comments From Stock Where Comments Like 'sum%'