Database record search using ADO [RESOLVED]

SELECT * FROM Handsets WHERE [Telephia_Asset_Number_Handset] LIKE "1234%"

You're using SQL Server - you can't use double quotes:
Replace

VB Code:

strWhere = strWhere & " AND [Telephia_Asset_Number_Handset] LIKE """ & Text2.Text & "*"""

with

VB Code:

strWhere = strWhere & " AND [Telephia_Asset_Number_Handset] LIKE [B]'[/B]" & Text2.Text & "*[B]'[/B]"