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.

I am casting the value like in Sybase same functionality I Want IN SQLSERVER 2000

2 posts in General Discussion Last posting was on 2005-04-04 15:25:48.0Z
karunakar Posted on 2005-04-04 14:41:11.0Z
From: "karunakar" <karunakarraop@stcroixsystems.com>
Newsgroups: ianywhere.public.general
Subject: I am casting the value like in Sybase same functionality I Want IN SQLSERVER 2000
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 203.115.124.42
X-Original-NNTP-Posting-Host: 203.115.124.42
Message-ID: <425143f7@forums-1-dub>
Date: 4 Apr 2005 06:41:11 -0800
X-Trace: forums-1-dub 1112622071 203.115.124.42 (4 Apr 2005 06:41:11 -0800)
X-Original-Trace: 4 Apr 2005 06:41:11 -0800, 203.115.124.42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4333
Article PK: 8148

Hi all

Iam using this function in sysbase is giving value
-- select cast(byte_substr(data,112,1) as Int )
when iam using this query in SQL SERVER 2000

Iam getting this ERROR : : 'byte_substr' is not a recognized function name.

Please help me

Thanku


Joshua Savill Posted on 2005-04-04 15:25:48.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <425143f7@forums-1-dub>
Subject: Re: I am casting the value like in Sybase same functionality I Want IN SQLSERVER 2000
Lines: 36
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <42514e6c$1@forums-1-dub>
Date: 4 Apr 2005 07:25:48 -0800
X-Trace: forums-1-dub 1112624748 10.25.98.205 (4 Apr 2005 07:25:48 -0800)
X-Original-Trace: 4 Apr 2005 07:25:48 -0800, jsavill-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4334
Article PK: 8150

The function BYTE_SUBSTR() exists in ASA. My guess is there is no function
implementation in SQL SERVER 2000 for BYTE_SUBSTR().

ASA documentation:

ASA SQL Reference
SQL Functions
Alphabetical list of functions
BYTE_SUBSTR function [String]

Online:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbrfen9/00000139.htm

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"karunakar" <karunakarraop@stcroixsystems.com> wrote in message
news:425143f7@forums-1-dub...
> Hi all
>
> Iam using this function in sysbase is giving value
> -- select cast(byte_substr(data,112,1) as Int )
> when iam using this query in SQL SERVER 2000
>
> Iam getting this ERROR : : 'byte_substr' is not a recognized function
> name.
>
> Please help me
>
> Thanku
>
>