Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: READTEXT and return values

    First question :

    How can I set the return value of READTEXT to a variable of type nvarchar.

    Second question :

    I have a table t1 with a ntext column n1.

    The ntext column has has words separated by empty space.
    Each word can be assumed to be of size <= 255 characters.

    How can I extract all the keywords in the ntext column to a table t2 with a column word nvarchar(255).

    Assume that the text in column n1 is big enough so that it cannot be cast into a nvarchar or any other simpler type.

    Any help on this is greatly appreciated.
    Please do provide a sample code.


  2. #2
    Join Date
    Aug 2002
    Have you referred to books online for READTEXT topoic.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts