Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access Query Syntax
Message
General information
Forum:
ASP.NET
Category:
Databases
Title:
Access Query Syntax
Miscellaneous
Thread ID:
01060601
Message ID:
01060601
Views:
49
Whats the correct syntax for pulling data from SQL using 'LIKE'?


This does not work
sTextVal = txtText.Text.Trim()

sSQLCommand = " select " & sSearchField & _
  " from " & sSearchAlias & _
  " where " & sSearchField & " like " & _
  sTextVal & "%"
This works fine
sTextVal = txtText.Text.Trim()

sSQLCommand = " select " & sSearchField & _
  " from " & sSearchAlias & _
  " where " & sSearchField & " = 'Electronic'"
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform