Function in sql

Question

hi anyone please help me how to create a function you need to pass a string value it return in proper case for example you pass the value "raja" it should be return "Raja" iam trying but iam not got correct output iam try to Upper case function Select UPPER('amudhan') it should return all letters are capital I need only first letter be capital how to do that please help me anyone

Ramesh Palanivel · Answer

Hi Amudhan, Refer this link, You will get answer for your question https://stackoverflow.com/questions/5164201/is-there-any-sql-server-built-in-function-to-convert-string-in-camel-case

Manav Pandya · Answer

Hello To do this , there is not predefined function available in sql server You can try below links : https://stackoverflow.com/questions/15290754/sql-capitalize-first-letter-only https://forums.asp.net/t/1828975.aspx?how+to+change+first+letter+as+capital+one+in+sql+ https://dba.stackexchange.com/questions/139382/capitalize-only-the-first-letter-of-each-word-of-each-sentence-in-sql-server https://social.msdn.microsoft.com/Forums/SECURITY/en-US/062f3e7c-9620-48af-80a4-af7330cf2bc8/need-to-capitalize-the-first-letter-only-and-leave-the-rest-lower-case-help-please?forum=transactsql https://www.sqlservercentral.com/Forums/Topic1219712-391-1.aspx Thanks

Manav Pandya · Answer

Hello Yes i know , thats why i told you that there is no predefined fuction available We need to do by implementing own logic , just check links i have given Try to do R & D , do not judge by just seeing the content Thanks

Shrimant Telgave · Answer

-------------------------- Following is the function created which will accept string and return string with first letter is in a capital letter.I hope this will help you to resolve your problem.this is not a pre define function. Custome function created as per the requirement . -------------------------- CREATE FUNCTION [dbo].[CapitalizeFirstLetter] ( --string need to format @string VARCHAR(200)--increase the variable size depending on your needs. ) RETURNS VARCHAR(200) ASBEGIN --Declare Variables DECLARE @Index INT, @ResultString VARCHAR(200)--result string size should equal to the @string variable size --Initialize the variables SET @Index = 1 SET @ResultString = '' --Run the Loop until END of the stringWHILE (@Index (@string)+1) begin="" if="" (@index="1)--first" letter="" of="" the="" string="" --make="" first="" capital="" set="" @resultstring="@ResultString" +="" upper(substring(@string,="" @index,="" 1))="" @index="@Index+" 1--increase="" index="" end="" --="" previous="" character="" is="" space="" or="-" next="" else="" ((substring(@string,="" @index-1,="" 1)=" " substring(@string,="" @index+1,="" )="" and="" @index+1=""> LEN(@string)) BEGIN --make the letter capital SET @ResultString = @ResultString + UPPER(SUBSTRING(@string,@Index, 1)) SET @Index = @Index +1--increase the index END ELSE-- all others BEGIN -- make the letter simple SET @ResultString = @ResultString + LOWER(SUBSTRING(@string,@Index, 1)) SET @Index = @Index +1--incerase the index END END--END of the loopIF (@@ERROR 0)-- any error occur return the sEND string BEGIN SET @ResultString = @string END -- IF no error found return the new string RETURN @ResultString END(@string)+1)>

Mohan Arumugam · Answer

https://www.aspdotnet-suresh.com/2015/09/sql-server-convert-string-to-proper-case-camel-case-title-case-function-example.html This link helps you Thanks

Amudhan Kuppan · Answer

Sorry Ramesh iam not understand because that link please see how it declare a input string 'microsoft sql server' after it will change 'Microsoft Sql Server' how? please send me another link or send me a query

Amudhan Kuppan · Answer

thank you mohan

Amudhan Kuppan · Answer

thank you manav

Amudhan Kuppan · Answer

iam not asking predefined function manav i need user defined function manav