Microsoft KB Archive/68230

= INF: Using Substring to Parse & Interpret Binary Data in SQL =

Article ID: 68230

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;bindata,&quot; use the following statement:

select substring(bindata,5,2)

Keywords: kbprogramming KB68230

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.