That works Ray.thanks for that

but guess what if i change query to

declare @x datetime

set @x= '29/june/2004'

select taskid,taskname,entrydt from task  where task.entrydt  = @x

it does not return any results.

Yes Ray, entrydt is datetime field.

i have 2 records with following dates

2004-06-29 16:32:08.000

2004-06-29 12:37:18.000

when i run following query

declare @x datetime

set @x= '29/06/2004'

select taskid,taskname,entrydt from task  where task.entrydt  >= @x...

Hi Ray

thanks for quick response.The reason i have ticks ' is am creating a dynamic sql from front end apps.

anyway i tried ur suggestion and unfortunatly did not work.

some of...

hi sqluser

Thank you very much for the links.

I get the idea

Hi sqluser

could u tell me which tool to use in visual studio to edit sql plz?

under my visual studion 6.0 menu there r many tools vb,foxpro and interdev etc.,

i am...

Thanks Mark.

I think i'm getting the idea

Phile what can i say that worked beautifully

Thank u very much

Thank u very much dbgeezer.I appreciate that

Thats wonderful Greg

finally i got it working.

Thank u very much