Problem in SQL Query in ASP
Posted on 2004-10-21
I m using Vbscript for asp with access database
In one page I need to fetch the records using the query
SELECT * FROM Data WHERE CTSNo Like '%2653%'
but this query doesn't fectch the records.
when I change the condition as '%265%
it shows one record which contains 265 string but not the record contaning 2653
when i check the qurey in Access as
SELECT * FROM Data WHERE CTSNo Like '*2653*'
it shows the records
What is the problem for Asp Page
I think the condition like 'condition%' works well
but the '%condition%' doesn't.
pls tell me urgent