I have some last names in a datagrid that I want to convert to UPPERCASE.
The easiest way I have found to do this is in the SQL statement. "Select Upper(Lastname) from Employee"
Here's the twist.
This is good for names like SMITH and JONES.
But how can I get this to work for a name like McLEAN or MacDONALD where the user wants those letters specified in lower case? (What are those types of names called?)
View Complete Post