- May 21, 2004
- 3,901
- 1
- 76
Hi
-On a windows application my partner and I are creating in Visual Basic (latest .net, vs2005 etc) we have a search which queries each column in a table using a wild card search.
However, one of the columns is a date column (datetime format). In addition, this column has been populating with local system times (so its something like "11/6/2006 6:06:32PM")
I was wondering what the best way to query this table would be (getting rid of the willdcard for the date column is, of course, acceptable).
Right now the wildcard search will give us results if we ONLY add a full year, but in no other case can we get any rows to return.
========
for the code below, the Top part is the SQL Query, the bottom it the VB code used to run the query
========
-On a windows application my partner and I are creating in Visual Basic (latest .net, vs2005 etc) we have a search which queries each column in a table using a wild card search.
However, one of the columns is a date column (datetime format). In addition, this column has been populating with local system times (so its something like "11/6/2006 6:06:32PM")
I was wondering what the best way to query this table would be (getting rid of the willdcard for the date column is, of course, acceptable).
Right now the wildcard search will give us results if we ONLY add a full year, but in no other case can we get any rows to return.
========
for the code below, the Top part is the SQL Query, the bottom it the VB code used to run the query
========
Facebook
Twitter