Sql statement problem

[vks.gautam1]

I am developing a VB project in which i want to search a value .& a text

In database i set
Mobile_no Field Text property .
now i want to search a no.

select * from table_name where mobile_no= ' " & textbox1.text & " '

But im not finding no.

Second i want to search a string how to write a query for this.

 

[vks.gautam1]

I am developing a VB project in which i want to search a value .& a text

In database i set
Mobile_no Field Text property .
now i want to search a no.

select * from table_name where mobile_no= ' " & textbox1.text & " '

But im not finding no.

Second i want to search a string how to write a query for this.

Now i have got where i was wrong i was giving space between ' & "

 

[cjard]

actually, youre forming your query entirely incorrectly.. read the PQ link in my signature to find out why