InfoPath Dev

I have a successful data connection, and in the udcx file, I have a SQL query that is successful, however i would like to use a T-SQL function LOWER() to return one particular column back in all lower case. When I try to do this, the column does not return any data. After some googling I have come up with zero leads on if it's even possible to do this. If this doesn't work, is there some way to have InfoPath parse the returned data from that query/column as lower case.. I'm trying to match an accountID in a person field with an Active Directory name in the SQL database, but the SQL table has a mixture of upper / lower case entries that im trying to normalize. Thanks RM

Can you switch your query to use a View? Or is this a main data source query?

This was a secondary data source. I ended up using a translate in the form so that it was able to normalize the data and do the comparison.

I'd still love to know if T-SQL is possible, I couldn't find anything in the DOCS. it doesn't seem like it works at all though.