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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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

06-01-2008 6:20pm

#1

grahamor

Registered Users, Registered Users 2 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

#2 06-01-2008 10: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