String functions in Sybase ASE

Question

I want to retrieve "name" from "My_name_is_ABC", how to do it in Sybase-ASE ?

I tried finding on internet but inbuild functions i saw are not supported in ase.

Atleast i need to know how to do find index of a string.

Rahul · Accepted Answer · 2014-07-11T20:05:20.533

0

Sybase ASE does have inbuilt string functions as Documented Here. You can use SUBSTRING and CHARINDEX function to get your desired result like below

select substring("My_name_is_ABC",charindex("_", "My_name_is_ABC")+1,4)

Syntax for Substring function : substring(expression, start, length )

edited Jul 11 '14 at 20:05

answered Jul 11 '14 at 19:56

Rahul

76,197
13
71
125

score 0 · Answer 2 · edited Dec 07 '16 at 08:04

0

select substr('My_name_is_ABC',locate('My_name_is_ABC','name'),4) from dummy

edited Dec 07 '16 at 08:04

Petter Friberg

21,252
9
60
109

answered Dec 07 '16 at 08:03

Akki

1

String functions in Sybase ASE

2 Answers2