5 Minute Project: SQL Statement to Capitalize 1st Letter of Fields in Specific Column -- 2

Hello Sir, I can start immediately. Lets wrap this straight away. Thanks a lot. Looking forward to work with you

Dear Employer, Greetings, I am ready to do the task, I can assure 100% satisfaction for quality work. You can read reviews/details about my past work on my profile http://www.freelancer.com/u/alyaspk.html Please feel free to ask any questions. Looking forward to fruitful response. Kind Regards, Muhammad Alyas

Hello, I can provide you the required SQL query straightforward. If you are interested please let me know. If you'd like to know more about my experience and skill set, you will find a detailed information of the key projects I have been working on as well as a complete list of my skill set in my Portfolio section. Best regards, K. Anagnostos

Hi, I can do this task for you which will make first letter capital in a field of column. Please message me for any queries. Thanks.

Dear Sir, Able to start right now. I have more than 2+ years experience in jquery,ajax,html,css,php, paypal integration and web based cms and frameworks like joomla,codegintter etc. I read all your description and know exactly what is needed to do and within timeline. I hope I am able to help you and I am waiting for your reply. Regards, bdphpguru

A proposal has not yet been provided

plz come on chat now so we can discuss more....am waiting... Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Regards, Bhagwan

Hello! You'll have to use a DB function. For example: DELIMITER // CREATE FUNCTION UC_WORDS(oldName VARCHAR(255), delim VARCHAR(1)) RETURNS VARCHAR(255) BEGIN SET @oldString := oldName; SET @newString := ""; tokenLoop: LOOP SET @splitPoint := LOCATE(delim, @oldString); IF @splitPoint = 0 THEN SET @newString := CONCAT(@newString, UC_FIRST(@oldString)); LEAVE tokenLoop; END IF; SET @newString := CONCAT(@newString, UC_FIRST(SUBSTRING(@oldString, 1, @splitPoint))); SET @oldString := SUBSTRING(@oldString, @splitPoint+1); END LOOP tokenLoop; RETURN @newString; END// DELIMITER ; After creating the function, you can use an SQL like this: SELECT UC_WORDS('testing-this-thing', '-', TRUE); Result will be "Testing-This-Thing". Another example with blank spaces: SELECT UC_WORDS('this is another test', ' ', TRUE); Result will be "This Is Another Test". Hope that helps. Alex.

A proposal has not yet been provided

UPDATE abc SET xyz = CONCAT(UCASE(LEFT(xyz, 1)), SUBSTRING(xyz, 2)); Basically that is. Do you mean something special by "of Fields in Specific Column"?

Hi, UPDATE tb_Company SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), SUBSTRING(CompanyIndustry, 2)); The above statement modify the table column CompanyIndustry from tb_Company table. This would turn hello to Hello, wOrLd to WOrLd, BLABLA to BLABLA Please award me :)

I have worked in various projects involving SQL queries. I can finish the work in no time and it will be delivered to you on time.

This is quite a simple task that I'll provide the necessary SQL statement straight up: SELECT CONCAT(UCASE(SUBSTRING(my_column, 1, 1)), SUBSTRING(my_column, 2)) FROM my_table

Have contributed a lot to the open source community through various projects on Github, I have a profound knowledge around MySQL* as well NoSQL databases. *A SQL query walks into a bar and sees two tables. He walks up to them and says ‘Can I join you? Then a waitress walks up and says ‘Nice view !

This is how you can achieve this in MS SQL server , I don't have My SQL here but it should be pretty straight forward. Select Upper(left(ltrim(column2),1))+lower(right(ltrim(column2),len(column2)-1)) from table

I must put a bid so that I can write the message. You do not need to pay anything. Use the following statement to capitalize first letter of all string values of particular column. SELECT concat(upper(substr(specific_column_name,1,1)), substr(specific_column_name,2)) FROM table_name;

It is simple: sample for select: select concat(ucase(MID(category_name, 1,1)), MID(category_name, 2)) AS category_name from table_name; But how you will having the statement? with best regards, Vatay

Hi, I have 4 years of strong experience in writing SQL, PL/SQL queries and is responsible for preparation of technical design documents, development and deployment of Conversion programs, Interfaces, XML Publisher Reports and Workflows with Oracle development tools and utilities including SQL*Plus, SQL*Loader, PL/SQL developer, BI Publisher, Workflow builder I believe I can help you around from the issue. Regards, Profez

Hi, you don't even have to pay me but I had to put in a minimum bid. I would like to just get a good rating so that I can start a review process on Freelancer so I can get higher paid jobs.

Hi, this is a easy job. Just need access to database and run SQL statement, even could you do it we my supervision.