hi

in my table date value is 2005-05-30 16:40:00

In select statement, i want to compare with 05/30/2005

can anyone tell me how to use date column in where clause

thanks
kalyan

You are in the wrong workgroup... but
select *
from tableName
where convert(varchar(24), tableColumn, 101) = '05/30/2005'

Rgds
JFB

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote