• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

select statement

   Iam having a problem in the select statement.
  My statement goes like this
  dim sPattern
  sPattern = request.form("txt")
select ruby from temp where ruby LIKE '% '" & sPattern &"'%'
Iam trying to extract the values from the ruby field where like the pattern contained in the variable.
I don't know its giving lot of run time errors.Please someone help me out in getting the correct syntax for this.

1 Solution
Try this :

select ruby from temp where ruby LIKE '%"& sPattern &"%'"

the single qoutes in between the % tags are wrong...
ragtanAuthor Commented:
Hello Siabod,
   Great Man,It worked for me.Thank you very much.Sorry man i don't have enough points in my account.otherwise definetly i prefer to give minimum 40 points for this.
Once again thank you very much keep helping me.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now