ragtan
asked on
select statement
Hello,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Tantri.