Viewing 2 posts - 1 through 2 (of 2 total)
select * from Table where convert(char(11),columnname,111) = 'datevalue' between 'datevalue'
With regards,
Karthikeyan
March 27, 2006 at 5:43 am
#628858
select * from T1 where custno not in (select custno from T2)
and OrderNo not in (selecct OrderNo from T2)
With Regards,
March 27, 2006 at 5:39 am
#628856