SQL SERVER Topic

MID() Function in SQL
The MID() function is used to extract characters from a text field.

Syntax:-

  

SELECT MID(column_name,start[,length]) AS some_name FROM table_name

--------------------------OR-----------------------------

SELECT SUBSTRING(column_name,start[,length]) AS some_name FROM table_name


Note:-The equivalent function for SQL Server is SUBSTRING().

Now, we are using SQL SERVER. So, first of all we create table tblProduct and insert some products as shown in belwo. 

  

CREATE TABLE tblProduct
(
ProductId int primary key,ProductName varchar(100),Quantity int, Price int,SupplierId int
)

----------Insert some record----------

INSERT INTO tblProduct VALUES(1001,'Product1',10,2000,1)
INSERT INTO tblProduct VALUES(1002,'Product2',20,9000,2)
INSERT INTO tblProduct VALUES(1003,'Product3',12,1200,2)
INSERT INTO tblProduct VALUES(1004,'Product4',9,200,3)
INSERT INTO tblProduct VALUES(1005,'Product5',25,1000,4)
INSERT INTO tblProduct VALUES(1006,'Product6',30,300,4)
INSERT INTO tblProduct VALUES(1007,'Product7',5,2000,1)
INSERT INTO tblProduct VALUES(1008,'Product8',18,4000,5)
INSERT INTO tblProduct VALUES(1009,'Product9',10,5000,6)



Example(1):- 

  


SELECT SUBSTRING(ProductName,1,4) AS ProductName FROM tblProduct