SUBSTRING FUNCTION IN SQLSERVER

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 494  View(s)
Ratings:
Rate this:
i wnat to use SUBSTRING FUNCTION  in Sqlserver please help me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: SUBSTRING FUNCTION IN SQLSERVER

    The SUBSTRING() function is used to extract a character string from a given starting position for a given length. 

    select CustomerID, SUBSTRING( CustomerName, 1, 4 ) as CustomerName,ContactName,Address,City,PostalCode,Country from Customer
    

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!