wildcard charcters
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
wild card characters are used to match strings as select * from table where name LIKE '%brown%'; but doesnt supports matching of dates,number what will we do if we want approximate matching of dates and numbers??
$h@ma!|@
You do a select like select * from table where created > DATEADD(month, -1, @date) and created < DATEADD(month, 1, @date) this searches for a date within a month on either side of the date provided.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )