CODEWITHSUNDEEP
functionreplacesybase
Preethi
Preethi

Reputation:

What is the equivalent function for REPLACE(of Oracle) in sybase

What is the equivalent function for REPLACE(of Oracle) in sybase?

Upvotes: 1

Views: 6434

Answers (2)

Steve
Steve

Reputation: 2093

How about using the Sybase Replace function?

http://manuals.sybase.com/onlinebooks/group-iq/iqg1250e/iqref/@Generic__BookTextView/37946;pt=37863

Syntax:

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

Example: SELECT REPLACE( 'abc.def.abc.ghi', 'abc', 'xx' ) FROM iq_dummy

Upvotes: 2

Guffa
Guffa

Reputation: 700362

I think that it's the str_replace function that you want.

As far as I can tell it's not an exact equivalent, as the third parameter is not optional, but the general usage is the same.

Upvotes: 3

Related Questions