Proper Case

Is there any way to convert to Proper Case in SQL Server? for lower case we
have LOWER and for upper case we have UPPER like that is there any thing for
proper case? if not how can we do this?You could always use a combination of the substr function. I think that
is the name in Oracle.
HTH|||xsluser wrote:
> Is there any way to convert to Proper Case in SQL Server? for lower
> case we have LOWER and for upper case we have UPPER like that is
> there any thing for proper case? if not how can we do this?
Best to do this on the client. But if you have to, you could write a
function to parse the string and turn it into proper case. Most dev tools
have a built-in PROPER function and this would be my recommendation of where
this type of formatting should be done. Or even better would be to get the
users to enter the information in the proper case to begin with.
David Gugick
Quest Software