Querying Sql Server

I'm having trouble retrieving one field from a table. Bascially i have two asp pages. On one u select a company field this then loads another page that finds the company details and posts it back to the first page etc.

Problem: The address field has line returns in it. When there aren't line returns it works perfectly otherwise it comes back with 'unterminated string error'.

In query analyzer my query works and i can use replace or update statements to remove
them in query analyzer however when i try that in an asp page it doesn't work.