change case of a text field
-
Hi all, I have a report created using data in a sqltable. table contains locations as following Location -------- STAPLE STREET LAKE AVENUE Hospital Road Main Street I dont wanna change them inside the table but i whish if i can chage them as following when in the select command Location -------- Staple Street Lake Avenue Hospital Road Main Street PLease tell me how to do this Regards Ruwandi rkherath
-
Hi all, I have a report created using data in a sqltable. table contains locations as following Location -------- STAPLE STREET LAKE AVENUE Hospital Road Main Street I dont wanna change them inside the table but i whish if i can chage them as following when in the select command Location -------- Staple Street Lake Avenue Hospital Road Main Street PLease tell me how to do this Regards Ruwandi rkherath
Do u want that field values should be displayed in Title Case rather than entirely lowercase / UPPERCASE?? Please clarify!!:)
Regards SG (sgg245@yahoo.co.in)