Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Location
    Hyderabad, India
    Posts
    16

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

    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!!
    -PavanKumar M Reddy

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    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
    Last edited by pdreyer; 02-17-11 at 11:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •