Square character in database table *Resolved *

[MarkusJ_NZ]

Hi all, I have a SQL Server 2000 database that has a table in it called
Person. One of the attributes is the persons address which is populated via
a VB.Net application.

A user is able to enter as up to four lines as their address in a text field
in the VB app. This information is then inserted into the SQL table via a
stored procedure.

I replace the line feed characters in the address before I send the Insert
string to the stored procedure.

My problem is that when I view the table with the addresses in it, whilst
the line feed characters have in fact been replaced there is also a little
square box (Unicode character) which has been inserted.

This little character is causing my application a few problems, so, how can
I get rid of it and also, why is it getting placed there in the first
place??

Thanks alot for any help
Cheers
Markus