MS SQL Server New Users - Unreadable character paced in front of valid data

Author

Unreadable character paced in front of valid data

David

2005-04-04, 8:04 pm

Using SQL2000 Server I have two programs that modify a field that I call
mod_user.
The table definition for this field is varchar 50 and the default is
(suser_sname()) I also have a trigger that updates the field when any of the
other row data changes, to the currently logged on user that makes the
changes. The application that is making the other changes is VC6++
application. This table is replicated and the users are logging onto a local
database running MDSE.

The data this is stored in the Field is the actual logged on user but the
first character in the user logon is replaced with a square. When running a
query this field is found in the query "where mod_user is < 'a' ". When the
query runs the fields look blank but upon clicking into the field with the
mouse you can see the data. I cannot copy the data from the table to here but
I could email someone a paint picture if necessary.

Any help would be greatly appreciated.

Sponsored Links