SQL MID() Function

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

SQL MID() Syntax
SELECT MID(column_name,start[,length]) FROM table_name
ParameterDescription
column_nameRequired. The field to extract characters from
startRequired. Specifies the starting position (starts at 1)
lengthOptional. The number of characters to return. If omitted, the MID() function returns the rest of the text

SQL MID() Example
We have the following "Persons" table:
P_IdLastNameFirstNameAddressCity
1HansenOlaTimoteivn 10Sandnes
2SvendsonToveBorgvn 23Sandnes
3PettersenKariStorgt 20Stavanger

Now we want to extract the first four characters of the "City" column above.

We use the following SELECT statement:

SELECT MID(City,1,4) as SmallCity FROM Persons
The result-set will look like this:
SmallCity
Sand
Sand
Stav

No comments: