Hi Gurus,

I have a "datein" column in a table with datatype
Datetime, which stored jobs come in date and time.

I want to list all jobs comes in a day. for this i
used the query given below;

Select * from jobs where datein like '%6/16/2003%'

But this query doesn't return any result though i have
jobs comes in today.

The datein values are stored as follows;

16-Jun-2003 14:30
16-Jun-2003 16:11

from these datas, this query should return 2 rows, but
didn't.

Advice please.

Advanced thanks for your help.



=====

Best Regards,
Bajal Mohamed.

Mobile : + 673 + 8611056

Time and tide wait for none






__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
MS Sql Server LazyDBA home page