• Thank you for your reply. Here is table defination :

    SELECT ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH

    , IS_NULLABLE

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'doctormst'

    DOCTORMST TABLE STRUCTURE

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECHARACTER_MAXIMUM_LENGHTIS_NULLABLE

    12accodechar8YES

    9activechar1YES

    6address1varchar40YES

    7address2varchar40YES

    10degreechar40YES

    16DesignationCodechar5YES

    1doctorcdchar5No

    5doctortypechar2YES

    14doctypechar1YES

    2firstnamevarchar15YES

    18honapplicablechar1YES

    4lastnamevarchar15YES

    15medicalregnovarchar15YES

    3middlenamevarchar15YES

    13mobilenochar15YES

    8phonevarchar30YES

    19tdstypecodechar3YES

    11titlevarchar4YES

    17WeekApplicablechar1YES

    For Unicode :

    When he run below queries, there were no output :

    select

    firstname,lastname,middlename

    from

    doctormst

    where

    firstname != cast(firstname as varchar(1000))

    select

    firstname,lastname,middlename

    from

    doctormst

    where

    lastname != cast(lastname as varchar(1000))

    select

    firstname,lastname,middlename

    from

    doctormst

    where

    middlename != cast(middlename as varchar(1000))

    So, it means, can we assume that there are no unicode character in these referenced columns please ?

    Regards

    Girish Sharma