Data with spaces is getting dropped

<i><b>Originally posted by : Kelly Ryan (kelly.ryan@mailcity.com)</b></i><br /><br />I am pulling a record out of a SQL database and populating onto a page using a RecordSet. My problem is anything that has a space in it- everything after the space does not get displayed. <br /><br />For Example: I have a field called Address and the value is '103 Main St.' but when I send that out to my page, the only thing I get is '103'. Any suggestions???<br /><br />Thank you so much for any and all input!!<br />Kelly

<i><b>Originally posted by : Gates</b></i><br />go to your page and put quotes around the values.<br />the problem is you're violating HTML specification.<br /><br /><br /><br />------------<br />Kelly Ryan at 4/13/2000 2:27:24 PM<br /><br /><br />I am pulling a record out of a SQL database and populating onto a page using a RecordSet. My problem is anything that has a space in it- everything after the space does not get displayed. <br /><br />For Example: I have a field called Address and the value is '103 Main St.' but when I send that out to my page, the only thing I get is '103'. Any suggestions???<br /><br />Thank you so much for any and all input!!<br />Kelly

I'm having a similar problem. My page takes inputted text from the user and adds it to a record in the database. Only the first word is added to the field if more words are entered. The field type is nvarchar so I dont understand why it wont capture the rest of the text. My statement looks like: SQL = "Insert into Individual (AirRequest) Values('" & Request.Form("AirRequest") & "')". What am I doing wrong?