I have a query that gets data to which fields in a GridView are bound. The data in the database is in all caps. I would like to change it all to lower case or -- even better -- proper case or title case. Can I do this in the query or in the BoundField with something like DataFormatString? The data are not dates, it's just plain ol' text. I've only ever used DataFormatString for currency and dates.
My query is below if that is of any assistance.
string strTestSQL = "SELECT [id], [mmap], [mlnam], [mfnam], [madd1] + ', ' + [madd2] + ', ' +[mzip5] as mailingAddress, [macre#], [mhse#] + ' ' + [mstrt] +' ' + [msttyp] as propertyAddress, [mdbook], [mdpage], [rec#alph], [minno#] FROM [tblCamraGIS] WHERE [REC#ALPH] LIKE '%" + txtRECALPH.Text + "%'";