Is there any function in Sybase to replace Initcap funtion in oracle

reddy_546 · #1 (**permalink**) 02-17-11, 00:22

I have data as "HYderabaD ROCKS and CHENNAI Sucks"...I want output as "Hyderabad rocks and chennai sucks".

How to get this using Sybase 15.0

Thanks a lot in advance!!

pdreyer · #2 (**permalink**) 02-17-11, 10:09

Create one yourself e.g.

Code:

create function dbo.intcap ( @c1 varchar(8000) )
returns varchar(8000) as
begin
  return upper(left(@c1,1))+lower(substring(@c1,2,7999))
end

Then you can use it e.g.

Code:

select dbo.intcap(name) from sysobjects

Internet Services

Web Development

Digital Marketing

Consumer Tech