SQL MID() Function
The 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 |
| Parameter |
Description |
| column_name |
Required. The field to extract characters from |
| start |
Required. Specifies the starting position (starts at 1) |
| length |
Optional. 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_Id |
LastName |
FirstName |
Address |
City |
| 1 |
Hansen |
Ola |
Timoteivn 10 |
Sandnes |
| 2 |
Svendson |
Tove |
Borgvn 23 |
Sandnes |
| 3 |
Pettersen |
Kari |
Storgt 20 |
Stavanger |
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:
Stylus Studio® 2010 XML Enterprise Suite raises the bar for productivity in XML development tools.
Millions of XML developers and data integration specialists turn to Stylus Studio's comprehensive and intuitive
XML toolset to tackle today's advanced XML data transformation and aggregation challenges.
|
- XML Pipeline Editor, Debugger and Code Generator
- DataDirect XML Converters
- XQuery Mapper, Editor, Debugger, and Profiler
- XSLT Mapper, Editor, Debugger, Designer, and Profiler
- Java and C# for .Net Code Generation
- XML Schema Designer With Documentation Generator
- XML Editor With Full XPath Integration
Download a free trial now
|
|
