Search in database

[Ali Rizwan]

How can i search for all records starting with the string A or any other string inputeed by user.

Thanx

[QVeen72]

Hi,

Use this Query and open the Recordset:

"Select * From MyTable Where FieldName Like 'A*'"

Regards
Veena

[Ali Rizwan]

Hi,

Use this Query and open the Recordset:

"Select * From MyTable Where FieldName Like 'A*'"

Regards
Veena

Hello Veena

This is not working.
I have used this code as

ADATA.CommandType = adCmdUnknown
    ADATA.RecordSource = "Select * From info Where Name Like '" & Text1.Text & "*'"
    ADATA.Refresh

thanx

[9815402440]

hi

use % in place of *

You my use _ (underscore) and % (percent) as wild cards. Use _ for one character and % for many charaters.

regards
manpreet singh dhillon hoshiarpur

[debasisdas]

How can i search for all records starting with the string A or any other string inputeed by user.

Thanx

use the following syntax

select * from table_name where field_name like 'A%'

if u r going for user input from textbox try this

sqlstr="select * from table_name where field_name like '" & trim(text1.text) & "%'"

[rizwan6feb]

Which database you are using at the backend ?

Microsoft Access uses '*' as the wildcard character, other Databases use '%'. For me there is no problem in the query if Microsoft Access is used at the backend.

[QVeen72]

Hello Veena

This is not working.
I have used this code as

ADATA.CommandType = adCmdUnknown
    ADATA.RecordSource = "Select * From info Where Name Like '" & Text1.Text & "*'"
    ADATA.Refresh

thanx

Try This :

ADATA.RecordSource = "Select * From info i Where i.Name Like '*" & Text1.Text & "*'"

* at both sides, ensures, middle of the name will also be searched..

Regards
Veena