SQL String Functions

select * from tbl1;

SELECT Fname,LEFT(Fname, 2) FROM tbl1;

SELECT Fname,RIGHT(Fname, 2) FROM tbl1;

SELECT Fname,LEN(Fname) FROM tbl1;

SELECT Fname,SUBSTRING(Fname, 2, 4) FROM tbl1;

SELECT Fname,PATINDEX('%na%', Fname)FROM tbl1;

SELECT Fname+city FROM tbl1;

SELECT Fname,REPLACE(Fname, 'a','') FROM tbl1;

INSERT INTO tbl1(Fname,age,city) SELECT Fname,age+12,city FROM tbl1;--we can select from other table also