Sorry about that, first time posting.
The table I'm querying looks like this (just a copy/paste of the create statement):
CREATE TABLE [dbo].[BasicAccountInfo](
[UserObjectSID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UserSourceDomain] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserFullName]...