Click here to Skip to main content
15,891,670 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: , +
how to print employeenames like below

1. first letter will be capital and remaining letters will be small in my table names

2. how to print required letters in lower case and remaining in uppercase by using sqlserver
Posted

AFAIK, there is nothing built in to SQL to do this: striung handling is not it's forte.

While you can do it, (this deals with Capitalising Each Word: http://stackoverflow.com/questions/5164201/is-there-any-sql-server-built-in-function-to-convert-string-in-camel-case[^] and it wouldn;t be hard to modify to exactly your requirement).
It would be a lot of effort in SQL and probably exactly the wrong place to do it - this is a data-entry and / or presentation conversion, and would probably be best done at that time. And a whole lot easier as well!
 
Share this answer
 
see the link, it will help you to create a stored procedure in sql server

http://vaidymohan.com/2012/05/27/t-sql-function-for-proper-case-format/

http://www.wisesoft.co.uk/scripts/tsql_proper_case_udf.aspx
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900