Home Forums SQL Server 2005 T-SQL (SS2K5) Inserting binary string at an offset to exsting data in a Text type field RE: Inserting binary string at an offset to exsting data in a Text type field

  • May 6, 2014 at 2:00 am

    #1710953

    Phil Parkin (5/6/2014)

    Text is a deprecated datatype - are you able to consider a datatype change? Varchar(max) or, even better, Varchar(nnn) if your column width won't exceed 8000.

    If yes, this update should be fairly trivial using STUFF().

    Thanks Phil, unfortunately the TEXT type is mandatory for the Spatialware software we are using, hence we are stuck on SQL Server 2005 until we get rid of it and move to SQL Server spatial types...

    D.