Hi Cetin

>Seeing ppl suggesting ways like this I wonder if FB doesn't support usual parameter passing? ie:

No Firebird is a beautiful thing. I had faced a similar problem to as Kerwam, so to get things working as of deadline I had gone this long way <g>. My advise give FireBird a try you won't regret it VFP and FB seems like they are cousins, if not real brothers/sisters <g>.

It will handle the following and more

>myDate = {^2005/1/1}
?sqlexec(nHandle,'INSERT INTO X (date) values ?m.myDate')>

Seems the bracket in my try was not required around ?m.myDate

>PS: RETURN "'" + TRANSFORM(dtoc(m.tdDate,1), "@R 9999/99/99") + "'"

Thanks for the correction to the function.