>cmd.CommandText = ...

>How sholud I write above statement but not using String.Format(). Only SELECT ... and
>what is required ?

cmd is an ADODB.Command object, right?

Use the cmd.CreateParameter() method and cmd.Parameters.Append() before cmd.Execute().

Bye, Olaf.