Very Computer

In SQL 7 is there any way or function to convert the first character of a
word to uppercase in a select statement or otherwise.

We are moving old mainframe data to SQL and it's all uppercase and it UGLY.

TIA,
Richard

see post "Quick Question - 28th Aug 01" from Itzik Ben-Gan

--

Quote:> In SQL 7 is there any way or function to convert the first character of a
> word to uppercase in a select statement or otherwise.

> We are moving old mainframe data to SQL and it's all uppercase and it
UGLY.

> TIA,
> Richard

The easiest way to do this is to provide a link in MS
Access for the table you want to update.  I don't know how
familar you are with Access but put the table in the
query  and choose update and choose the field you want to
update. In the Update To field insert StrConv
([FieldName],3) this will update all your records to
Proper Case.

Quote:>-----Original Message-----
>In SQL 7 is there any way or function to convert the

first character of a

Quote:>word to uppercase in a select statement or otherwise.

>We are moving old mainframe data to SQL and it's all

uppercase and it UGLY.

Quote:

>TIA,
>Richard

>.

try
update table_name set column_name = UPPER(SUBSTRING(LTRIM
(column_name),1,1)) + LOWER(SUBSTRING(column_name,2, x))
from table_name

where x is the column length

first character of a

Quote:>> word to uppercase in a select statement or otherwise.

>> We are moving old mainframe data to SQL and it's all
uppercase and it
>UGLY.

>> TIA,
>> Richard

>.