Home Forums Programming General Problem working with nvarchar over 6 digits RE: Problem working with nvarchar over 6 digits

  • Here's the DDL:

    patidpri,int,no,4,10 ,0 ,no,(n/a),(n/a),NULL

    ClientID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL

    CProviderID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL

    PhysicianID,int,no,4,10 ,0 ,yes,(n/a),(n/a),NULL

    PatientID,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    Birthdate,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    PriDiag,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    SecDiag1,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    SecDiag2,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    Medications,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    Allergies,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    NANDA,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    Notes,ntext,no,16, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    Dev_100_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_200_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_300_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_400_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_500_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_600_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_700_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_700_Target,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_700_Concern,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_800_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Dev_900_Start,datetime,no,8, , ,yes,(n/a),(n/a),NULL

    Cp_team,nvarchar,no,100, , ,yes,(n/a),(n/a),SQL_Latin1_General_CP1_CI_AS

    upsize_ts,timestamp,no,8, , ,yes,(n/a),(n/a),NULL