Home Forums SQL Server 2005 Administering convert ntext to varchar RE: convert ntext to varchar

  • June 9, 2011 at 3:05 pm

    #1336740

    Lowell (6/9/2011)

    here's the full reference to Cast And Convert; it's good to read, it's something you end up using a lot

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

    Select

    convert(nvarchar(max),TheNTextColumn) AsColumnName

    From TableName

    I need to convert and replace with varchar data type. Dont i need to run an update statement after i change?

    update dbo.mytable set mycolumn = mycolumn

    ?