hi Wes,

i'm using c#, so i should substitute the & with + on my code. i'll try your suggestion.

i've also found my mistake on the original approach of using parameters. i did not assign a value before i issued the ExecuteNonQuery(). adding the line below fixed the problem. thanks for your help.

cmd.Parameters[0].Value=date1;