>I am trying to create a string depending on the cursor fields & its type to be used to pass it to insert command for SQL server.
>I am having 2 problems
>1> How to include character fields with quotes, square brackets & other special characters.
>2> How to send date fields.
>
>Rajesh

Rather than build a string and worry about data types, etc. is it possible to just pass in the values via parameters? For example something like

SQLEXEC(lnConnection,"INSERT INTO mysqltable 
                      (field1,field2,...fieldn)
                      VALUES (?mycursor.value1,?mycursor.value2,...?mycursor.valuen)")