INF: Using Substring to Parse & Interpret Binary Data in SQL (68230)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q68230
The following information discusses how the substring() function for
string functions allows the user to store data in a binary field and
then interpret the data 1 or more bytes at a time.
The syntax for the substring() function is listed below:
substring(colname,starting position,length)
For example, to get 2 bytes starting from the fifth position from a
field called "bindata," use the following statement:
select substring(bindata,5,2)
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbProgramming KB68230 |
|---|
|