Skip to Content
avatar image
Former Member

Checking for title case

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers