Hello,



When you insert your value into SQL,



Use the Command Convert(varchar,5.1) which will convert the number 5.1

to char.





-----Message d'origine-----

De=A0: Stefan Rijkaart van Cappellen [mailto:stefanrvc@h...]

Envoy=E9=A0: Saturday, August 25, 2001 8:17 PM

=C0=A0: ASP Databases

Objet=A0: [asp_databases] Problem inserting a comma seperated value in 

SQL

server with ASP



Hello,



I am using an SQL server 7 dbase to store a comma seperated value in one



of the tables. When I do this via an ASP page the value is stored as an

integer. E.g. I want to store the value 5.1, SQL server stores it as 51.



The same problem occurs when I do this directly in SQL server (so

without

ASP code).



Any ideas?



Kind regards

Stefan