RE: LIKE and % is just not enough. Advanced SQL Search help neede d

2004-05-04 Thread Steve Nelson
Calling this a little processor intensive would be a gross understatement. If you have any significant amount of data within your database, any one of these queries will be a lot of work for your database server, as it'll involve a table scan. If you really want to do these sorts of searches and

RE: LIKE and % is just not enough. Advanced SQL Search help neede d

2004-05-04 Thread Dave Watts
Calling this a little processor intensive would be a gross understatement. If you have any significant amount of data within your database, any one of these queries will be a lot of work for your database server, as it'll involve a table scan. If you really want to do these sorts of

RE: LIKE and % is just not enough. Advanced SQL Search help neede d

2004-05-04 Thread Steve Nelson
True, it's not the most scalable solution, I'm sure there are more efficient ways to achieve the same thing. But from Jason's email it sounds like massive scalability is not the biggest concern, I think at this point he's simply trying to return the most accurate results to help his users achieve