Hi all,

I am having a little trouble with using the % in my query. When I do a query like this

SELECT *
FROM windowevents2 where ComputerName = 'Lab01' and
Datetime = '%'

I get a return of empty set

But when I use this query

SELECT *
FROM windowevents2 where ComputerName = 'Lab01' and
Datetime = 'Tue Feb 10 15:30:30 2004'

I do get all the results for that search date. Any insight on why this is so? Thanks for any help.

Correct query is:

SELECT *
FROM windowevents2 where ComputerName = 'Lab01' and
Datetime like '%'
Because when you use "=" then the column must have exact entry.

Thank you very much for ur help.