Replace the string '102' located at offset 9 (zero-based) with the string 'one hundred and two' : VARCHAR « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. VARCHAR

7> IF OBJECT_ID('dbo.CustomerData') IS NOT NULL
8>   DROP TABLE dbo.CustomerData;
9> GO
1>
2> CREATE TABLE dbo.CustomerData
3> (
4>   custid      INT            NOT NULL PRIMARY KEY,
5>   txt_data    VARCHAR(MAX)   NULL,
6>   ntxt_data   NVARCHAR(MAX)  NULL,
7>   binary_data VARBINARY(MAX) NULL
8> );
9> GO
1>
2> UPDATE dbo.CustomerData
3>   SET txt_data.WRITE('one hundred and two', 9, 3)
4> WHERE custid = 102;
5> GO
1>
2> drop table CustomerData;
3> GO