Skip to Content
0

Checking for title case

Apr 20, 2017 at 09:38 AM

13

avatar image

I wanted to know if there is an easier way of checking whether a var-char field is in Title case format. any suggestions?

This is what i came up with...

DECLARE

# Variable to store result of substring of the Item Description

$Is_Capital varchar(1);

BEGIN

$Is_Capital = substr($Item_Description, 1, 1);

IF($Is_Capital = upper($Is_Capital)) RETURN TRUE;

ELSE RETURN FALSE;

END

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers