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
1. changing capitalization in a table
Is there a command you can run on a field or entire table to change any data
that may have lowercase letters in the data to all caps?
Thanks,
Buster
3. Changing DBSERVERNAME - correction
4. No case sensitivity with SQL query?
5. correction :select duplicate and non duplicate record
6. Oracle 8.0 (Defrag and 8i) questions
7. MySQL: Selecting multiple rows for update - CORRECTION
8. Usenet
9. Data Correction for - Efficient Select statement need
10. Change my select statement in a CRecordSet class SELECT VERIABLE1, COUNT(*)
11. TS-SQL: Capitalization not required on some servers
12. Need Capitalization routine
13. SET Query for capitalization