Capitalization changes/corrections in Select

Capitalization changes/corrections in Select

Post by Andrew G. Smit » Tue, 30 Jul 1996 04:00:00



I've got a couple of views that are exported to create mass mailings.  
The problem is some information is ALL CAPS, all lowercase, etc.  Does
anyone have a standard process for their select statements to rewrite
these columns normally?

ex.
first_name ANDREW
last_name SMITH
middle_init G
Change to export as: Andrew G Smith

Thanks!
--
Andrew G. Smith
Butler Clinical Recruitment Inc.
7721 Six Forks Road, Suite 140
Raleigh, NC, 27615