like statment

[Fary4u]

Hi

i'm trying to search the value in my following field. i don't know why it's giving me this error

select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%"&styno&"%'") ")

without wildcard it's works fine but wd wildcard gives error
Unterminated string constant. ?

[Fary4u]

yes sorted but executed query but no result found ?

select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%" & styno & "%') ")

still can't find the styno value

[Atli]

Hi.

Can you show us what the query looks like after you construct it?

Meaning:
[code=vb]
Dim colValue As String = "someValue"
Dim sql As String = "SELECT * FROM myTbl WHERE col = '" & colValue & "'"

Response.Write( sql) ' What would this show you?
[/code]

[Fary4u]

Hi thanks for ur reply

the problem is not in query anymore it's bring the result but it's not searching value in the variable but variable values passing parameters ? ? ? ?

i'm very much confused wht's going on ? ? ?

my DB Values like this

CatalogID  |  productDess
1  |  x / y / z
2  |  A / B / C
3  |  1 / 2 / 3

result should b like this

(CatalogID='2') AND (productDescc like '%B%')

coding

select * FROM products WHERE (products.CatalogID='" & strCatalogID & "') AND (products.productDescc like '%" & styno & "%') ")

it's working fine & donig the same i would like to do but not returning value from " B " result

[Atli]

That query, executed against that data (overlooking the column name typo) should only return the second row

the problem is not in query anymore it's bring the result but it's not searching value in the variable but variable values passing parameters ? ? ? ?

I'm afraid I don't understand what you are saying here.
Could you try to explain this a little better?

Aside from that, there are a couple of things that you might want to look into.

1. Numeric values in queries should not be quoted, like your CatalogID.
   It should be [code=mysql](CatalogID=2)[/code]
   (Assuming CatalogID is an integer)
   
   
2. Your productDescc column is storing multiple values.
   This violates the most basic rule of relational database design.
   Each field should only contain a single value, and never a list of values.
   See this article on Database Normalization and Table Structures to learn more.