Two SMS 2003 servers, one returns different data format for same query.

Problem When doing a database query via SQL, one of our Microsoft SMS 2003 Servers (MILDRED) was returning an incorrect number of characters (8) for a field.  The field was supposed to return 56 characters.

As we were getting correct returns from the other SMS 2003 Server (GEORGE), we knew our T-SQL query was [...]