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.

Want to create case in-sensitive index in Sybase 12.5

2 posts in General Discussion Last posting was on 2005-10-11 02:23:27.0Z
Ravi Srivastava Posted on 2005-10-10 21:30:07.0Z
From: "Ravi Srivastava" <ravi.kumar.srivastava@citigroup.com>
Newsgroups: ianywhere.public.general
Organization: 192.193.220.149
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Want to create case in-sensitive index in Sybase 12.5
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: web110.discountasp.net
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <434add5f$1@forums-1-dub>
Date: 10 Oct 2005 14:30:07 -0700
X-Trace: forums-1-dub 1128979807 64.79.161.40 (10 Oct 2005 14:30:07 -0700)
X-Original-Trace: 10 Oct 2005 14:30:07 -0700, web110.discountasp.net
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4847
Article PK: 31458

Greetings,

Can anyone please let me know how to create case insensitive index in
sybase 12.5. I am trying to do following but its not working for me..

create index tbl_index
on table_name(uppder(column_name))

but its giving syntax error at first occurance of "("

Please advise..
-Ravi
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Chris Keating (iAnywhere Solutions) Posted on 2005-10-11 02:23:27.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <434add5f$1@forums-1-dub>
Subject: Re: Want to create case in-sensitive index in Sybase 12.5
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
NNTP-Posting-Host: cpe001217e36468-cm012059936305.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm012059936305.cpe.net.cable.rogers.com
Message-ID: <434b221f@forums-1-dub>
Date: 10 Oct 2005 19:23:27 -0700
X-Trace: forums-1-dub 1128997407 24.112.219.40 (10 Oct 2005 19:23:27 -0700)
X-Original-Trace: 10 Oct 2005 19:23:27 -0700, cpe001217e36468-cm012059936305.cpe.net.cable.rogers.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4848
Article PK: 17446

You should post this to an ASE focused newsgroup. This group is targeted
towards iAnywhere products.

/ck

"Ravi Srivastava" <ravi.kumar.srivastava@citigroup.com> wrote in message
news:434add5f$1@forums-1-dub...
> Greetings,
>
> Can anyone please let me know how to create case insensitive index in
> sybase 12.5. I am trying to do following but its not working for me..
>
> create index tbl_index
> on table_name(uppder(column_name))
>
> but its giving syntax error at first occurance of "("
>
> Please advise..
> -Ravi
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp