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:

Dim colValue As String = "someValue"
Dim sql As String = "SELECT * FROM myTbl WHERE col = '" & colValue & "'"
 
Response.Write(sql) ' What would this show you?
 

[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

@Fary4u
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

   (CatalogID=2)

   (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.