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