If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

is there s sql function similar to c# ToTitleCase method

grahamor · 2008-01-06 18:20:41

Hi, As the subject says, i am wondering if there is a built in function for converting a string to title case i.e. : /// "THE dog JuMpS" as an input string will be returned as /// "The Dog Jumps" Thanks in advance

Options

06-01-2008 7:20pm

#1

grahamor

Registered Users Posts: 872 ✭✭✭

Join Date: August 2005

Posts: 557

Hi,

As the subject says, i am wondering if there is a built in function for converting a string to title case i.e. :

/// "THE dog JuMpS" as an input string will be returned as
/// "The Dog Jumps"

Thanks in advance

0

Comments

Options
#2 06-01-2008 11:02pm
Cantab.

Closed Accounts Posts: 1,444 ✭✭✭

Join Date: December 2005

Posts: 1337

http://dev.mysql.com/doc/refman/5.0/en/regexp.html

0