Function in sql

Amudhan Kuppan

8y1kSQL

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel8y ago
Accepted 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
Amudhan Kuppan8y ago
thank you mohan
Amudhan Kuppan8y ago
thank you manav
Manav Pandya8y ago
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
Amudhan Kuppan8y ago
iam not asking predefined function manav
i need user defined function manav
Shrimant Telgave8y ago
-------------------------- 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 Arumugam8y ago
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
Manav Pandya8y ago
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
Amudhan Kuppan8y ago
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