sql asp 500pts

WhereString =   "SubString(Stock_Master.Bond_No,6,len(Stock_Master.Bond_No)) ='" & bondno & "' ORDER BY Stock_Master.Bond_No asc"  
I have partial of sql statement, and above sql code makes my query really slow. Is anyway I can use some other codes to make it faster?
500pts                                        
riskyricky1972Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dportasCommented:
Is this for Oracle or SQL Server or something else? It's always wise to state the product and version.

Try using a LIKE expression in place of = and SUBSTRING.

Your code looks dangerously vulnerable to SQL injection. There will be a proper way to do parameterisation in your host language of choice and you really ought to be using it.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
for sql 2000:
create a computed column for the substring() expression, index that field, and do the search using that computed column


if it had been for oracle:
create a function-based index on that substring() expression, and the query would take that index automatically without changing that query
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.