>where alltrim(cocode) = ?
>.Parameters.Add(New OleDbParameter("@oacode", OleDbType.VarChar, 10)).Value
>= strName
>When the strName is blank, (it return all the record)
>How can I correct it ??
>I am using vfpoledb.dll

Use "==" insetad of "=" or set ansi on.
PS: Alltrim() is unnecessary BTW. Either you need ltrim() or nothing (ltrim() only if you have spaces on left).
Cetin