Answer: SUBSTR is used for string manipulation with column name, first position and string length used as arguments.
Example:
SELECT LastName, SUBSTRING(FirstName, 1, 1) AS Initial
FROM Person.Contact
WHERE LastName like 'Barl%'
ORDER BY LastName
Result:
LastName Initial
--------------------------------- -------
Barley R
Barlow B
(2 row(s) affected)
Asked In: Many Interviews |
Alert Moderator