Insert query to insert name into db

Question

I want to store my user information into database with Uname first letter upper case and lname first letter uppercase. Doesn't matter how user insert data, it should be store in db as

Input: sachin tendulkar
Database: Sachin Tendulkar

I need Insert query for this. I know we can use update / select query but specially looking for insert query.

Appreciate your answer.

Thanks,

What DBMS are you using? (MySQL, SQL-Server, Oracle, etc...)? — Stanislovas Kalašnikovas, Feb 03 '16 at 07:25
Also first and last names are stored in one or separate columns? — Stanislovas Kalašnikovas, Feb 03 '16 at 07:28
Possible duplication : http://stackoverflow.com/questions/5164201/is-there-any-sql-server-built-in-function-to-convert-string-in-camel-case — Ubiquitous Developers, Feb 03 '16 at 07:28
You'll need a trigger to take care of the Capitalization. Tag dbms used, since triggers are usually product specific. (Only a very few dbms products have ANSL SQL triggers.) — jarlh, Feb 03 '16 at 07:35

Stanislovas Kalašnikovas · Answer 1 · 2016-02-03T07:50:50.020

0

In SQL Server. If first and last names are stored in separate columns you can do something like:

CREATE TABLE #Tbl
(
    FirstName NVARCHAR(MAX)
)
DECLARE @FirstName NVARCHAR(MAX) = 'tom'

INSERT INTO #Tbl (FirstName) VALUES (UPPER(LEFT(@FirstName,1))+LOWER(SUBSTRING(@FirstName,2,LEN(@FirstName))))

edited Feb 03 '16 at 07:50

answered Feb 03 '16 at 07:35

Stanislovas Kalašnikovas

9,203
4
32
59

Insert query to insert name into db

1 Answers1