... I hope
I have a table with a couple of varchar columns that needs to have all it
values all capitalized.
SO this :
id|last_name|first_m |login_id|sex
----+---------+---------+--------+---
1231|Reid |Samuel R.|sreid |M
would become :
id|last_name|first_m |login_id|sex
----+---------+---------+--------+---
1231|REID |SAMUEL R.|sreid |M
This way when I bring them up alphabetically - it will be correct.
I remember seeing this on the list a couple of months ago but I cannot
remember the fix...
Thanks for any advice
Summer