LIKE Operator

[smallfish]

I have tried to get results from SELECT Query with :
WHERE Field LIKE '111*' (demo)
throughe DataAdapter.Fill() function but it does not work, while in the database (Access) it is.

why should i do ??

[DdH]

Use '%' instate of '*'

Danny

[smallfish]

working