I need the equivalent function for ASA :

ORACLE : translate function
ASA : ??????????? what is the equivalent function.
I need to translate accent caracters.

In article <4432e0ea.513.1681692777 (AT) sybase (DOT) com>, Timrek says...
We might be able to help more if we knew the translate function does?

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

takes characters in one string and replaces them 1:1 for those in another.


select ('abba', 'abc', 'def' ) from dual

returns deed because the first "a" is the first character in "abc" and
it's replaced with the first character in "def" which is a "d")







Sybase newsgroups wrote:

The CSCONVERT function translates characters from one character set to
another, but I'm not familiar with what the Oracle translate function does,
so I've no idea if this is what you're looking for.

See the following section in the docs :

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

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


<Timrek> wrote

What about the REPLACE() function?

REPLACE ( original-string, search-string, replace-string )

Bob


"Daniel Coppersmith" <daniel_AT_infrontsoftware_DOT_com (AT) N0SPAM (DOT) com> wrote in
message news:4432d9e5$1 (AT) forums-2-dub (DOT) ..

Just to clarify: I assume you mean

select TRANSLATE('abba','abc','def') from dual

"Daniel Coppersmith" <daniel_AT_infrontsoftware_DOT_com (AT) N0SPAM (DOT) com> wrote in
message news:4432d9e5$1 (AT) forums-2-dub (DOT) ..

Yes. As in all my software, I have implemented the elusive RTUM
technology in Oracle as well.

All the software can Read The Users' Mind. As such, I have to type
much much less.

In fact, often times, entire applications are written as:


// Do it.

Neat technology!









Andrew Giulinn wrote:

Beautiful - when are you free to help out with our project?

"Daniel Coppersmith" <daniel_AT_infrontsoftware_DOT_com (AT) N0SPAM (DOT) com> wrote in
message news:44331419$1 (AT) forums-1-dub (DOT) ..

On 4 Apr 2006 20:21:11 -0800, "Andrew Giulinn"
<NO.oscar.SPAM (AT) NOSPAM (DOT) dsa.com.au> wrote:

He already has... go have a look, it's all done



--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com

Good grief - you're right!

See you then - I'm off to the pub.

I assume your work comes with 24/7 support Daniel?

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter (AT) risingroad (DOT) com> wrote in
message news:h1d732lg8ep5a6a2h1vdneli98oe0b5u5i (AT) 4ax (DOT) com...