Which Ado code do you used ?
By default if you use this code in ADO
parameter.DbType =
DbType.String;ADO will send this parameter as nvarchar(XX), you must specify the SqlDbType to VarChar to send it as VarChar
With iBATIS to sent a Sql Server VarChar SqlDbType, used the attribute dbType="VarChar"
--
Cheers,
Gilles
<a href="" href="http://www.amazon.com/gp/registry/6JCP7AORB0LE" target="_blank"> http://www.amazon.com/gp/registry/6JCP7AORB0LE ">Wish List</a>
