hyperlink datatype in sql

  • HI. I have been asked to convert an Access Database into a sql 2000 database.  One of the field types in the access database is 'hyperlink'. I have looked into BOL and I do not see any data type comparable. Is this even possible? 

    Thank you,

    Juanita

  • There is no hyperlink datatype as what you have in MS ACCESS you have to convert this datatype to varchar and use your application logic to convert that to hyperlink field in the application.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Thank you so much !!

    and love your saying underneath your name

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply