Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Convert to Upper case

5 posts in General Discussion Last posting was on 2008-08-06 15:31:23.0Z
Loya Posted on 2008-08-06 13:20:00.0Z
Reply-To: "Loya" <lkelso@isprit.com>
From: "Loya" <lkelso@isprit.com>
Newsgroups: ianywhere.public.general
Subject: Convert to Upper case
Lines: 17
Organization: Isprit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4899a500@forums-1-dub>
Date: 6 Aug 2008 06:20:00 -0700
X-Trace: forums-1-dub 1218028800 10.22.241.152 (6 Aug 2008 06:20:00 -0700)
X-Original-Trace: 6 Aug 2008 06:20:00 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7007
Article PK: 5231

We are on version 9.0.2 EBF 3044

I have a field that we want to convert to upper case data in the database.

Here's what I tried, but I got an error message on the word Upper.

SELECT convert (cpt_descriptor, UPPER)
FROM "dbo"."cpt_longul_2005"

Any suggestions, other than downloading to Excel and making them upper and
then re-importing?

Thanks,
Loya


Mark Culp Posted on 2008-08-06 14:14:59.0Z
Message-ID: <4899B1E2.8CB2EDD2@iAnywhere.com>
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Convert to Upper case
References: <4899a500@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 6 Aug 2008 07:14:59 -0700
X-Trace: forums-1-dub 1218032099 10.22.241.152 (6 Aug 2008 07:14:59 -0700)
X-Original-Trace: 6 Aug 2008 07:14:59 -0700, vip152.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7008
Article PK: 5232

Use
select upper( cpt_descriptor )
from "dbo"."cpt_longul_2005"
--
Mark Culp
SQLAnywhere Research and Development
iAnywhere Solutions Engineering
-------------------------------------------------------------------------
-- SQL Anywhere Blog Center - http://www.sybase.com/sqlanyblogs
-- SQL Anywhere Developer Community:
-- http://www.sybase.com/developer/library/sql-anywhere-techcorner
-------------------------------------------------------------------------

Loya wrote:
>
> We are on version 9.0.2 EBF 3044
>
> I have a field that we want to convert to upper case data in the database.
>
> Here's what I tried, but I got an error message on the word Upper.
>
> SELECT convert (cpt_descriptor, UPPER)
> FROM "dbo"."cpt_longul_2005"
>
> Any suggestions, other than downloading to Excel and making them upper and
> then re-importing?
>
> Thanks,
> Loya


Loya Posted on 2008-08-06 14:44:48.0Z
Reply-To: "Loya" <lkelso@isprit.com>
From: "Loya" <lkelso@isprit.com>
Newsgroups: ianywhere.public.general
References: <4899a500@forums-1-dub> <4899B1E2.8CB2EDD2@iAnywhere.com>
Subject: Re: Convert to Upper case
Lines: 42
Organization: Isprit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4899b8e0$1@forums-1-dub>
Date: 6 Aug 2008 07:44:48 -0700
X-Trace: forums-1-dub 1218033888 10.22.241.152 (6 Aug 2008 07:44:48 -0700)
X-Original-Trace: 6 Aug 2008 07:44:48 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7009
Article PK: 5233

I did that and it changed it on the screen, but not in the database table.
What is the next step to save it in upper case in the database?

Thanks,
Loya


"Mark Culp" <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>

wrote in message news:4899B1E2.8CB2EDD2@iAnywhere.com...
> Use
> select upper( cpt_descriptor )
> from "dbo"."cpt_longul_2005"
> --
> Mark Culp
> SQLAnywhere Research and Development
> iAnywhere Solutions Engineering
> -------------------------------------------------------------------------
> -- SQL Anywhere Blog Center - http://www.sybase.com/sqlanyblogs
> -- SQL Anywhere Developer Community:
> -- http://www.sybase.com/developer/library/sql-anywhere-techcorner
> -------------------------------------------------------------------------
>
> Loya wrote:
>>
>> We are on version 9.0.2 EBF 3044
>>
>> I have a field that we want to convert to upper case data in the
>> database.
>>
>> Here's what I tried, but I got an error message on the word Upper.
>>
>> SELECT convert (cpt_descriptor, UPPER)
>> FROM "dbo"."cpt_longul_2005"
>>
>> Any suggestions, other than downloading to Excel and making them upper
>> and
>> then re-importing?
>>
>> Thanks,
>> Loya


Mark Culp Posted on 2008-08-06 15:21:15.0Z
Message-ID: <4899C16A.8CC5B8EB@iAnywhere.com>
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Convert to Upper case
References: <4899a500@forums-1-dub> <4899B1E2.8CB2EDD2@iAnywhere.com> <4899b8e0$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 6 Aug 2008 08:21:15 -0700
X-Trace: forums-1-dub 1218036075 10.22.241.152 (6 Aug 2008 08:21:15 -0700)
X-Original-Trace: 6 Aug 2008 08:21:15 -0700, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7010
Article PK: 5234

If you actually want to change the database content, then you need to
execute an UPDATE statement...
update "dbo"."cpt_longul_2005"
set cpt_descriptor = upper( cpt_descriptor );

- Mark

Loya wrote:
>
> I did that and it changed it on the screen, but not in the database table.
> What is the next step to save it in upper case in the database?
>
> Thanks,
> Loya
>
> "Mark Culp" <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
> wrote in message news:4899B1E2.8CB2EDD2@iAnywhere.com...
> > Use
> > select upper( cpt_descriptor )
> > from "dbo"."cpt_longul_2005"
> > --
> > Mark Culp
> > SQLAnywhere Research and Development
> > iAnywhere Solutions Engineering
> > -------------------------------------------------------------------------
> > -- SQL Anywhere Blog Center - http://www.sybase.com/sqlanyblogs
> > -- SQL Anywhere Developer Community:
> > -- http://www.sybase.com/developer/library/sql-anywhere-techcorner
> > -------------------------------------------------------------------------
> >
> > Loya wrote:
> >>
> >> We are on version 9.0.2 EBF 3044
> >>
> >> I have a field that we want to convert to upper case data in the
> >> database.
> >>
> >> Here's what I tried, but I got an error message on the word Upper.
> >>
> >> SELECT convert (cpt_descriptor, UPPER)
> >> FROM "dbo"."cpt_longul_2005"
> >>
> >> Any suggestions, other than downloading to Excel and making them upper
> >> and
> >> then re-importing?
> >>
> >> Thanks,
> >> Loya


Loya Posted on 2008-08-06 15:31:23.0Z
Reply-To: "Loya" <lkelso@isprit.com>
From: "Loya" <lkelso@isprit.com>
Newsgroups: ianywhere.public.general
References: <4899a500@forums-1-dub> <4899B1E2.8CB2EDD2@iAnywhere.com> <4899b8e0$1@forums-1-dub> <4899C16A.8CC5B8EB@iAnywhere.com>
Subject: Re: Convert to Upper case
Lines: 58
Organization: Isprit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4899c3cb$1@forums-1-dub>
Date: 6 Aug 2008 08:31:23 -0700
X-Trace: forums-1-dub 1218036683 10.22.241.152 (6 Aug 2008 08:31:23 -0700)
X-Original-Trace: 6 Aug 2008 08:31:23 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7011
Article PK: 5235

Thank you, yes that is what I want to do!


"Mark Culp" <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>

wrote in message news:4899C16A.8CC5B8EB@iAnywhere.com...
> If you actually want to change the database content, then you need to
> execute an UPDATE statement...
> update "dbo"."cpt_longul_2005"
> set cpt_descriptor = upper( cpt_descriptor );
>
> - Mark
>
> Loya wrote:
>>
>> I did that and it changed it on the screen, but not in the database
>> table.
>> What is the next step to save it in upper case in the database?
>>
>> Thanks,
>> Loya
>>
>> "Mark Culp"
>> <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
>> wrote in message news:4899B1E2.8CB2EDD2@iAnywhere.com...
>> > Use
>> > select upper( cpt_descriptor )
>> > from "dbo"."cpt_longul_2005"
>> > --
>> > Mark Culp
>> > SQLAnywhere Research and Development
>> > iAnywhere Solutions Engineering
>> > -------------------------------------------------------------------------
>> > -- SQL Anywhere Blog Center - http://www.sybase.com/sqlanyblogs
>> > -- SQL Anywhere Developer Community:
>> > --
>> > http://www.sybase.com/developer/library/sql-anywhere-techcorner
>> > -------------------------------------------------------------------------
>> >
>> > Loya wrote:
>> >>
>> >> We are on version 9.0.2 EBF 3044
>> >>
>> >> I have a field that we want to convert to upper case data in the
>> >> database.
>> >>
>> >> Here's what I tried, but I got an error message on the word Upper.
>> >>
>> >> SELECT convert (cpt_descriptor, UPPER)
>> >> FROM "dbo"."cpt_longul_2005"
>> >>
>> >> Any suggestions, other than downloading to Excel and making them upper
>> >> and
>> >> then re-importing?
>> >>
>> >> Thanks,
>> >> Loya