Question: ```
//ACCESS
SELECT DISTINCT products.imageUrl FROM products WHERE ((products.pcprod_ParentPrd=5573) AND (products.pcprod_Relationship LIKE '*441*'));

//ASP
SELECT DISTINCT products.imageUrl FROM products WHERE ((products.pcprod_ParentPrd="&pidProduct&") AND (products.pcprod_Relationship LIKE '*"&rsCS("idoptoptgrp")&"*'));

```

this query works when i'm manually running the query in Access database. but when I run it from ASP. it doesn't return and rows

Answer: 
@user670111: In your ASP you have to use `%` instead of `*` as the wild-card character.

So rewrite your query in ASP as 

```
SELECT DISTINCT products.imageUrl FROM products WHERE (products.pcprod_ParentPrd = " & pidProduct & ") AND (products.pcprod_Relationship LIKE '%" & rsCS("idoptoptgrp") & "%')

```
Maybe the values of pidProduct & rsCS("idoptoptgrp") are not what you are expecting it to be?

Does it work when you try ...
`((products.pcprod_ParentPrd=" & 5573 & ") AND (products.pcprod_Relationship LIKE '*" & 441 & "*'));`